/*
 Navicat Premium Data Transfer

 Source Server         : 119.23.210.212
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : 119.23.210.212:3306
 Source Schema         : t_sale_assistant

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 02/11/2020 10:14:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_app
-- ----------------------------
DROP TABLE IF EXISTS `t_app`;
CREATE TABLE `t_app` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `app_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '应用名称',
  `image_url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片地址',
  `app_link` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'app超链接地址地址',
  `access_model` tinyint(1) DEFAULT NULL COMMENT '接入方式：1,内部;2,接入;3,外链',
  `deleted` tinyint(255) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  `sort` int(8) DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_app
-- ----------------------------
BEGIN;
INSERT INTO `t_app` VALUES (20, '账号管理', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-09-29/1601320113870_32910', '无', 1, 0, 1);
INSERT INTO `t_app` VALUES (21, '产品管理', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-09-29/1601320124488_4c95d', '无', 1, 0, 2);
INSERT INTO `t_app` VALUES (22, '宣传系统', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-09-29/1601320133769_1a0eb', '无', 1, 0, 3);
COMMIT;

-- ----------------------------
-- Table structure for t_app_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_app_menu`;
CREATE TABLE `t_app_menu` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `menu_id` bigint(64) NOT NULL COMMENT '菜单主键id',
  `app_id` bigint(64) NOT NULL COMMENT 'app主键id',
  `menu_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单名称',
  `app_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用名称',
  `parent_menu_id` bigint(64) DEFAULT NULL COMMENT '父菜单主键id',
  `link` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '菜单链接',
  `parent_menu_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '父菜单名称',
  PRIMARY KEY (`id`),
  KEY `menu_app` (`menu_id`,`app_id`)
) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_app_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_app_menu` VALUES (159, 30, 21, '产品信息', '产品管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (160, 31, 21, '供应商信息', '产品管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (161, 32, 21, '版本信息', '产品管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (162, 33, 21, '功能信息', '产品管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (163, 5, 22, '区域信息', '宣传系统', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (164, 7, 22, '员工管理', '宣传系统', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (165, 8, 22, '账号管理', '宣传系统', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (166, 9, 22, '账号管理', '宣传系统', 8, '', NULL);
INSERT INTO `t_app_menu` VALUES (167, 10, 22, '角色管理', '宣传系统', 8, '', NULL);
INSERT INTO `t_app_menu` VALUES (168, 11, 22, '内容发布', '宣传系统', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (169, 12, 22, '内容发布', '宣传系统', 11, '', NULL);
INSERT INTO `t_app_menu` VALUES (170, 13, 22, '内容审核', '宣传系统', 11, '', NULL);
INSERT INTO `t_app_menu` VALUES (171, 14, 22, '产品发布', '宣传系统', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (172, 15, 22, '分类管理', '宣传系统', 14, '', NULL);
INSERT INTO `t_app_menu` VALUES (173, 16, 22, '分类模板', '宣传系统', 14, '', NULL);
INSERT INTO `t_app_menu` VALUES (174, 17, 22, '学习模式', '宣传系统', 16, '', NULL);
INSERT INTO `t_app_menu` VALUES (175, 18, 22, '宣传模式', '宣传系统', 16, '', NULL);
INSERT INTO `t_app_menu` VALUES (176, 19, 22, '产品管理', '宣传系统', 14, '', NULL);
INSERT INTO `t_app_menu` VALUES (177, 20, 22, '审核发布', '宣传系统', 14, '', NULL);
INSERT INTO `t_app_menu` VALUES (178, 21, 22, '案例管理', '宣传系统', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (179, 22, 22, '案例查看', '宣传系统', 21, '', NULL);
INSERT INTO `t_app_menu` VALUES (180, 23, 22, '统计分析', '宣传系统', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (181, 24, 22, '总体概况', '宣传系统', 23, '', NULL);
INSERT INTO `t_app_menu` VALUES (182, 25, 22, '使用趋势', '宣传系统', 23, '', NULL);
INSERT INTO `t_app_menu` VALUES (183, 26, 22, '系统配置', '宣传系统', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (184, 27, 22, '参数配置', '宣传系统', 26, '', NULL);
INSERT INTO `t_app_menu` VALUES (185, 28, 22, '栏目管理', '宣传系统', 26, '', NULL);
INSERT INTO `t_app_menu` VALUES (186, 29, 22, 'banner管理', '宣传系统', 26, '', NULL);
INSERT INTO `t_app_menu` VALUES (187, 1, 20, '应用管理', '账号管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (188, 2, 20, '应用角色', '账号管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (189, 3, 20, '机构管理', '账号管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (190, 4, 20, '员工管理', '账号管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (191, 5, 20, '区域信息', '账号管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (192, 6, 20, '机构管理', '账号管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (193, 7, 20, '员工管理', '账号管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (194, 8, 20, '账号管理', '账号管理', 0, '', NULL);
INSERT INTO `t_app_menu` VALUES (195, 9, 20, '账号管理', '账号管理', 8, '', NULL);
INSERT INTO `t_app_menu` VALUES (196, 10, 20, '角色管理', '账号管理', 8, '', NULL);
INSERT INTO `t_app_menu` VALUES (197, 26, 20, '系统配置', '账号管理', 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_app_role
-- ----------------------------
DROP TABLE IF EXISTS `t_app_role`;
CREATE TABLE `t_app_role` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `app_role_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '应用角色名称',
  `user_count` int(8) DEFAULT '0' COMMENT '用户个数',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0：非删除状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_app_role
-- ----------------------------
BEGIN;
INSERT INTO `t_app_role` VALUES (1, '超级管理员', 2, 0);
INSERT INTO `t_app_role` VALUES (28, '宣传系统管理员', 0, 0);
INSERT INTO `t_app_role` VALUES (29, '产品与账号管理员', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_app_role_relation
-- ----------------------------
DROP TABLE IF EXISTS `t_app_role_relation`;
CREATE TABLE `t_app_role_relation` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `app_role_id` bigint(64) DEFAULT NULL COMMENT '应用角色id',
  `app_id` bigint(64) DEFAULT NULL COMMENT '应用id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `app_role` (`app_role_id`,`app_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_app_role_relation
-- ----------------------------
BEGIN;
INSERT INTO `t_app_role_relation` VALUES (80, 1, 20);
INSERT INTO `t_app_role_relation` VALUES (81, 1, 21);
INSERT INTO `t_app_role_relation` VALUES (82, 1, 22);
INSERT INTO `t_app_role_relation` VALUES (79, 26, 22);
INSERT INTO `t_app_role_relation` VALUES (59, 27, 20);
INSERT INTO `t_app_role_relation` VALUES (60, 27, 21);
INSERT INTO `t_app_role_relation` VALUES (83, 28, 22);
INSERT INTO `t_app_role_relation` VALUES (84, 29, 20);
INSERT INTO `t_app_role_relation` VALUES (85, 29, 21);
INSERT INTO `t_app_role_relation` VALUES (86, 29, 22);
COMMIT;

-- ----------------------------
-- Table structure for t_app_role_staff
-- ----------------------------
DROP TABLE IF EXISTS `t_app_role_staff`;
CREATE TABLE `t_app_role_staff` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `app_role_id` bigint(64) DEFAULT NULL COMMENT '应用角色id',
  `staff_id` bigint(64) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `approlestaff` (`app_role_id`,`staff_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=349 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_app_role_staff
-- ----------------------------
BEGIN;
INSERT INTO `t_app_role_staff` VALUES (284, 1, 1);
INSERT INTO `t_app_role_staff` VALUES (315, 1, 2);
INSERT INTO `t_app_role_staff` VALUES (341, 1, 58);
INSERT INTO `t_app_role_staff` VALUES (323, 28, 59);
INSERT INTO `t_app_role_staff` VALUES (322, 28, 60);
INSERT INTO `t_app_role_staff` VALUES (321, 28, 61);
INSERT INTO `t_app_role_staff` VALUES (332, 28, 62);
INSERT INTO `t_app_role_staff` VALUES (334, 28, 63);
INSERT INTO `t_app_role_staff` VALUES (335, 28, 64);
INSERT INTO `t_app_role_staff` VALUES (336, 28, 65);
INSERT INTO `t_app_role_staff` VALUES (337, 28, 66);
INSERT INTO `t_app_role_staff` VALUES (338, 28, 67);
INSERT INTO `t_app_role_staff` VALUES (339, 28, 68);
INSERT INTO `t_app_role_staff` VALUES (346, 28, 70);
INSERT INTO `t_app_role_staff` VALUES (347, 28, 71);
INSERT INTO `t_app_role_staff` VALUES (348, 28, 72);
INSERT INTO `t_app_role_staff` VALUES (345, 29, 69);
COMMIT;

-- ----------------------------
-- Table structure for t_area
-- ----------------------------
DROP TABLE IF EXISTS `t_area`;
CREATE TABLE `t_area` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `area_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '区域名称',
  `parent_area_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '上级区域名称',
  `parent_area_id` bigint(64) DEFAULT '0' COMMENT '上级区域主键',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of t_area
-- ----------------------------
BEGIN;
INSERT INTO `t_area` VALUES (55, '巴中', '', 0);
INSERT INTO `t_area` VALUES (56, '成都', '', 0);
INSERT INTO `t_area` VALUES (57, '蓉城', '', 0);
INSERT INTO `t_area` VALUES (58, '达州', '', 0);
INSERT INTO `t_area` VALUES (59, '德阳', '', 0);
INSERT INTO `t_area` VALUES (60, '广安', '', 0);
INSERT INTO `t_area` VALUES (61, '广元', '', 0);
INSERT INTO `t_area` VALUES (62, '乐山', '', 0);
INSERT INTO `t_area` VALUES (63, '泸州', '', 0);
INSERT INTO `t_area` VALUES (64, '眉山', '', 0);
INSERT INTO `t_area` VALUES (65, '绵阳', '', 0);
INSERT INTO `t_area` VALUES (66, '南充', '', 0);
INSERT INTO `t_area` VALUES (67, '内江', '', 0);
INSERT INTO `t_area` VALUES (68, '攀枝花', '', 0);
INSERT INTO `t_area` VALUES (69, '遂宁', '', 0);
INSERT INTO `t_area` VALUES (70, '雅安', '', 0);
INSERT INTO `t_area` VALUES (71, '宜宾', '', 0);
INSERT INTO `t_area` VALUES (72, '资阳', '', 0);
INSERT INTO `t_area` VALUES (73, '自贡', '', 0);
INSERT INTO `t_area` VALUES (74, '青羊', '成都', 56);
COMMIT;

-- ----------------------------
-- Table structure for t_article
-- ----------------------------
DROP TABLE IF EXISTS `t_article`;
CREATE TABLE `t_article` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `article_module_id` bigint(64) DEFAULT '0' COMMENT '栏目主键',
  `article_module_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '栏目名称',
  `article_title` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '文章标题',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `issue_time` datetime DEFAULT NULL COMMENT '发布时间',
  `issue_person` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '发布人',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态：1,草稿;2,审核中;3,已驳回;4,审核通过',
  `read_count` int(8) DEFAULT '0' COMMENT '阅读数量',
  `article_content` text COLLATE utf8mb4_unicode_ci COMMENT '文章内容',
  `creator` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建人',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  `address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '地点',
  `org_id` bigint(64) DEFAULT NULL COMMENT '创建人机构id',
  `image_url` text COLLATE utf8mb4_unicode_ci COMMENT '图片url',
  `audit_org_id` bigint(64) DEFAULT NULL COMMENT '审核机构Id',
  `article_desc` text COLLATE utf8mb4_unicode_ci COMMENT '文章描述',
  `audit_person` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '审核人',
  `article_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '文章标签',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_article
-- ----------------------------
BEGIN;
INSERT INTO `t_article` VALUES (71, 1, '1', '让学生爱上历史，一台神器帮到你', '2020-10-21 14:54:27', '2020-10-28 11:12:37', '超级管理员', 4, 101, '<p style=\"text-align: justify;\">2019年10月，第77届中国教育装备展示会在青岛市世博城国际博览中心盛大开幕。活动首日举行了&ldquo;<strong>文轩趣学|妙懂课堂移动历史教室</strong>&rdquo;<strong>新品发布会。</strong></p>\n<p><span style=\"background-color: #917d62; color: #ffffff;\">不枯燥的课堂是什么样的？<br /></span></p>\n<p style=\"text-align: justify;\">发布会上，一堂科技感十足的历史课让历史教学活了起来：无论是&ldquo;720度VR全景漫游&rdquo;、&ldquo;3D互动文物&rdquo;、&ldquo;虚拟博物馆&rdquo;让历史教学重难点变得栩栩如生，还是&ldquo;互动板书&rdquo;、&ldquo;导图点记&rdquo;演绎知识必考点、&ldquo;优选课件&rdquo;让历史教学知识点变得简单易记&hellip;&hellip;都吸引了大量观展嘉宾与省内外媒体。</p>\n<p style=\"text-align: justify;\"><span style=\"color: #ffffff; background-color: #917d62;\">&nbsp;技术让学习更有广度、深度&nbsp; <br /></span></p>\n<p style=\"text-align: justify;\">历史的学习过程应是去伪存真、全面思考和思辨分析的过程。而&ldquo;科技+历史&rdquo;课堂使得历史不再是一门枯燥、晦涩的学科。得益于这些先进的教学辅助技术与丰富的教学资源，让师生可以从不同的史实实证材料中寻觅逻辑性和法理性，兴趣盎然地思辨与分析。</p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;</p>\n<p><img style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603234427389_a628b.GIF\" alt=\"\" width=\"100\" height=\"67\" /></p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;</p>', '超级管理员', 0, '青羊区', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603234378449_2a615.png', NULL, '第77届中国教育装备展示会，一件学科神器闪亮全场', '', '历史');
INSERT INTO `t_article` VALUES (72, 1, '1', '移动历史教室，从“拥有它”到“它有用”', '2020-10-21 15:07:10', '2020-10-28 11:12:39', '超级管理员', 4, 35, '<p style=\"text-align: justify;\">自19年上市以来，&ldquo;移动历史教室&rdquo;参与到了全省各市州、区县的教研活动、师资培训等活动，惠及全省300余所初中学校。</p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #917d62; color: #ffffff;\">构建历史高效课堂</span></p>\n<p style=\"text-align: justify;\">2020年6月，在达州市初中历史学科教学系列研讨会上，全市30余所学校的100多名初中历史教师参与学习交流。示范学校的历史教师以&ldquo;抓好教学主阵地，构建信息化高效课堂&rdquo;为主题，讲解了如何用移动历史教室提高课堂效率，辅助教师高校备授课；其中，移动历史教室同步部编版历史教材的基础上，加入了更丰富的数字教学资源，使以往全靠想象力的教学内容通过三维模型、虚拟现实等技术得到精彩呈现。</p>\n<p style=\"text-align: justify;\"><span style=\"color: #ffffff; background-color: #917d62;\">教学难题的创新解决方案</span></p>\n<p style=\"text-align: justify;\">&nbsp;在培训会交流讨论环节，老师们根据自己一线教学的经历，不断抛出：资源调用是否复杂、如何保证每节课的教学效率等问题。而优选课件、一键切换等贴近教学实际的功能，为这些信息化教学难点提供了创新可行的解决方案。</p>\n<p style=\"text-align: justify;\"><span style=\"color: #ffffff; background-color: #917d62;\">减负增质的新选择</span></p>\n<p style=\"text-align: justify;\">为教师减负，为教学增质，已成为各地区教育改革的重要行动之一。不断降低使用门槛，提高实用效率，也正是每一所学校对于新时代教育信息化装备提出的新期许。</p>\n<p><img style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603235159115_07dfa.GIF\" alt=\"\" width=\"100\" height=\"75\" /></p>', '超级管理员', 0, '青羊区', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603235065293_7e42e.png', NULL, '移动历史教室，从“拥有它”到“它有用”', '', '历史');
INSERT INTO `t_article` VALUES (73, 1, '1', '课堂变成博物馆，近距离领略历史之美', '2020-10-21 15:26:32', '2020-10-28 11:12:41', '超级管理员', 4, 40, '<blockquote>\n<p style=\"text-align: justify;\"><sup>题记：古文字是远古时代流传到今天的文明火花，弥足珍贵。汉字历经甲骨文，金文，小篆，隶书，楷书，行书，草书，从繁体字到简体字，再到如今网络上流行的新造字，历经时间淘洗，却一直保持旺盛的生命力。</sup></p>\n</blockquote>\n<p style=\"text-align: justify;\">2019年11月，由成都市教育科学研究院主办的&ldquo;蜀都杯&rdquo;2019年成都市初中历史教师优质课展评活动，吸引到来自各区县的26位教师同台竞技,砥砺成长。</p>\n<p style=\"text-align: justify;\">天府中学（川大附中历史备课组长）罗琳玉老师以&ldquo;古文字&rdquo;为主题，借助文物&mdash;&mdash;虹刻辞牛骨的3D模型以及背后商王问卜的故事解读，对《青铜器与甲骨文》进行课程展示。在这堂课上，罗老师以小见大，把一堂历史课变成了一堂博物馆的研学课，让学生近距离感受古文字、古文物、古文化中的深刻内涵，激发学生们对于古文字的兴趣。而富有想象力和美感的汉字文化与历史自豪感也润物细无声地融进了学生们的骨血，蓬勃焕发出华夏民族独特精神气质。</p>\n<p style=\"text-align: justify;\">最终经过激烈角逐，最终罗琳玉老师荣获此次初中历史优质课大赛特等奖。</p>\n<p><video controls=\"controls\" width=\"100\" height=\"50\">\n<source src=\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603235639109_7defc.mp4\" type=\"video/mp4\" /></video></p>', '超级管理员', 0, '青羊区', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603235527285_c39b6.png', NULL, '课堂变成博物馆，近距离领略历史之美', '', '历史');
INSERT INTO `t_article` VALUES (74, 1, '1', '在乡村教育角落，科技之光也可照见', '2020-10-21 16:09:46', '2020-10-28 11:41:53', '超级管理员', 4, 62, '<p style=\"text-align: justify;\">宜宾市凉水井中学是一所需要绕过24道弯的山路才能到达的偏远乡村学校，也是中国土地上成百上千普通寄宿制初中中的一所。但它却吸引了十几个省市上百名校长到学校参访。</p>\n<p style=\"text-align: justify;\"><strong>是什么魅力把全国各地的校长、教师吸引到这里来的呢？</strong></p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #48a8e5; color: #ffffff;\">乡村教育改革先锋</span></p>\n<p style=\"text-align: justify;\">凉水井中学在升学竞争激烈、生源减少、教师流失、教学资源匮乏等诸多压力下，经历了三波教育改革的过程，先是被困境推着走，在外出学习其他地方课堂改后回来囫囵吞枣，照搬小组合作学习，结果是教学质量下降，引起老师对课堂改革反感，陷入极大的困境。</p>\n<p>在困难面前，团队继续坚持改革，进行反思调整，最终采取在教学质量课内指导学生学会制作和预习导学案，让学生结队发展，并让能力突出的学生像老师一样在黑板面前讲解，教师成为教练的角色，展开问题驱动型的课堂，极大的提高了学习效率和学生学习能力，走出困境。</p>\n<p style=\"text-align: justify;\"><span style=\"color: #ffffff; background-color: #48a8e5;\">地理课堂的科技之光</span></p>\n<p style=\"text-align: justify;\">学校继而在更广阔的视野中找到教育变革的大方向，把技术开放和工具推广的人和机构引入学校，创设出与新技术紧密结合的教学流程，并带动学习思维方式，关键枢纽环节变革，丰富的学生的学习场景和课程，打破了学校围墙，让学生开始实现无边界的学习，有了更广阔成长的空间。</p>\n<p style=\"text-align: justify;\">而在一节地理课上正不断传出热烈的惊叹声：凉水井中学的地理学科何老师在为学生们上了一堂《地球的运动》的课程，通过生活中学生们常见的生活现象（昼夜交替，四季变化等），引出了课堂的主要内容&mdash;&mdash;地球的运动，何老师应用&ldquo;AR难点妙懂&rdquo;模块，为学生们呈现了生动立体的地球自转、公转，基于AR立体画面呈现，分小组进行学习讨论总结。</p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #48a8e5; color: #ffffff;\">解决问题，解放师生</span></p>\n<p style=\"text-align: justify;\">凉水井中学在教育改革中的宗旨就是帮助教师、学生更好解决学习中的问题，如节省时间、提升效率、提高书写、减轻教师负担等，在核心能力上要做到极致。而地理课堂也只是凉水井中学提升教学效率等诸多课程改革的一个小小缩影。</p>\n<p><video controls=\"controls\" width=\"300\" height=\"150\">\n<source src=\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603664338335_adb9b.mp4\" type=\"video/mp4\" /></video></p>\n<p><span style=\"color: #000000;\">来源：| 宜宾市翠屏区凉水井初级中学校、<span style=\"line-height: 21px;\">中国教师报、新校长传媒</span></span></p>', '超级管理员', 0, '宜宾', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603238898229_90a32.png', NULL, '在乡村教育角落，科技之光也可照见', '', '地理');
INSERT INTO `t_article` VALUES (75, 1, '1', '带到哪儿，哪儿就是地理课堂', '2020-10-21 16:31:37', '2020-10-28 12:13:54', '袁健智', 4, 27, '<p style=\"text-align: justify;\">为全面贯彻落实教育部高效课堂的教学要求，有效解决地理课堂教学中出现的实际问题，充分利用现代教学辅助教学手段实现课堂教学直观、生动、形象、有趣&ldquo;四性&rdquo;，绵阳市游仙区教师进修学校针对全区地理教师组织开展了为期一天的全员技能培训。</p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #48a8e5; color: #ffffff;\">信息技术融合下的地理课堂变革</span></p>\n<p style=\"text-align: justify;\">来自成都七中嘉祥外国语学校地理教师白云松做了&ldquo;现代信息技术融合变革下的地理课堂&rdquo;的主题分享，通过对&ldquo;初中地理教师怎样构建高效有趣的地理课堂&rdquo;问题的探究，比较了现代信息技术融合变革下的地理课堂相对于传统地理课堂的优势，强调了营造信息化教学环境对于初中地理课堂的重要性和必要性。</p>\n<p style=\"text-align: justify;\">最后，白老师结合自身一线教学的经验，与老师们分享了自己在课堂中是怎样运用AR地理学科产品进行教学。</p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #48a8e5; color: #ffffff;\">突破空间思维局限，知识难点快速掌握</span></p>\n<p style=\"text-align: justify;\">&ldquo;这种将AR技术辅助地理教学的方式，真的颠覆了传统地理课堂教学方式，让今天的参培老师们眼前一亮，今后真的可以实现&rsquo;带到哪儿，哪儿就是地理课堂&rsquo;，打破学生空间思维局限，帮助他们对知识难点进行轻松理解快速掌握，真的很不错。&rdquo;绵阳市游仙区教师进修学校王校长体验后说道。</p>\n<p><img src=\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240278659_1fc2b.GIF\" alt=\"\" width=\"100\" height=\"75\" /></p>', '袁健智', 0, '青羊区', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240198489_c508d.png', NULL, '带到哪儿，哪儿就是地理课堂', '', '地理');
INSERT INTO `t_article` VALUES (76, 1, '1', '他屡登湖南卫视，就因为上课有意思', '2020-10-21 16:56:21', '2020-10-28 12:13:51', '袁健智', 4, 47, '<p style=\"text-align: justify;\">湖南卫视10月9日播出的《我的纪录片:科技地理 有意思的课堂》让更多人认识了一位有趣的地理老师&mdash;&mdash;罗春。</p>\n<p style=\"text-align: justify;\">而来自成都市教科院附属学校的罗春老师，一直以&ldquo;课堂教学创新&rdquo;闻名地理教师圈。对于一些初中地理学科教学的难点，罗老师也常常感叹道:&ldquo;讲20多分钟，学生似乎都不太容易懂&rdquo;。</p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #48a8e5; color: #ffffff;\">老师讲得清楚，学生听得明白</span></p>\n<p style=\"text-align: justify;\">当了解到&ldquo;文轩趣学|地理资源包&rdquo;之后，罗老师通过运用其中的AR技术，将学生平时通过平面图形不容易理解的知识点（等高线、公转与自转等），通过虚拟成像展示出来，让学生去观察、去触碰，甚至是去操作，极大地调动起了孩子的好奇心和自主学习能力。</p>\n<p style=\"text-align: justify;\"><span style=\"color: #ffffff; background-color: #48a8e5;\">很棒的地理课堂是什么样的？</span></p>\n<p style=\"text-align: justify;\">&ldquo;&rsquo;很棒&rsquo;的课堂从来都不仅仅是老师一个人的事情，更多的去倾听学生的内心，去发现他们觉得有意思的学习方式，这才是地理课堂。&rdquo;罗春老师声音坚定地说着。</p>\n<p><video controls=\"controls\" width=\"100\" height=\"50\">\n<source src=\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603241729574_4cf75.mp4\" type=\"video/mp4\" /></video></p>', '袁健智', 0, '青羊区', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240961426_5562c.png', NULL, '他屡登湖南卫视，就因为上课有意思', '', '地理');
INSERT INTO `t_article` VALUES (77, 1, '1', '一封感谢信，共同抗疫情', '2020-10-21 16:59:18', '2020-10-28 12:16:39', '袁健智', 4, 33, '<p style=\"text-align: justify;\">受新冠肺炎疫情影响，教育部、四川省教育厅发布了中小学校延迟开学的通知。虽然开学日期不确定，&ldquo;课前到书&rdquo;工作却箭在弦上。</p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #c01a30; color: #ffffff;\">组织资源，共抗疫情</span></p>\n<p style=\"text-align: justify;\">为抗击疫情，保障教师有书用、学生有书看，新华文轩采用&ldquo;互联网+教育&rdquo;的形式，迅速组织资源研发&ldquo;文轩教学资源中心学科电子教材栏目&rdquo;。</p>\n<p style=\"text-align: justify;\">同时，携手人民教育出版社、北京师范大学出版社、外语教学与研究出版社、华东师范大学出版社、西南师范大学出版社、教育科学出版社等20余家出版社，通过文轩教学资源中心平台为广大师生免费提供学科电子教材，方便师生在防护疫情的同时，做到&ldquo;停课不停学&rdquo;。</p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #c01a30; color: #ffffff;\">坚守责任，屡获认可</span></p>\n<p style=\"text-align: justify;\">&ldquo;莫道浮云终蔽日，冬尽春来满庭芳&rdquo;，文轩坚守责任与担当，得到了中共四川省委教育工作委员会、四川省教育厅等教育主管部门的广泛认可。</p>\n<p><img src=\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603241940036_88ea6.JPG\" alt=\"\" width=\"100\" height=\"216\" /></p>', '袁健智', 0, '青羊区', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603241890662_37f43.png', NULL, '一封感谢信，共同抗疫情', '', '资源中心');
INSERT INTO `t_article` VALUES (78, 1, '1', '评比活动，促进备课方式再升级', '2020-10-21 17:04:22', '2020-10-28 12:13:47', '袁健智', 4, 60, '<blockquote>\n<p style=\"text-align: justify;\">题记：教师备课，如同影视导演编写脚本，事前功夫的优劣，直接决定着具体操作中的成败。</p>\n</blockquote>\n<p style=\"text-align: justify;\">2020年9月-12月，四川省教育信息化应用与发展研究中心、四川教育发展研究会联合组织开展&ldquo;2020年全省中小学教师备课资源评比活动&rdquo;。</p>\n<p style=\"text-align: justify;\"><span style=\"color: #ffffff; background-color: #c01a00;\">好教师，变身好导演</span></p>\n<p style=\"text-align: justify;\">为提升教师在备课环节中的信息化与学科融合能力，作为活动独家支持单位的四川文轩教育科技公司多次开展在线直播课程，特邀到四川智慧教育联盟秘书长、成都师范学院周鑫燚教授带来了《融合创新从备课开始》的专题讲座，为教师们提供最前沿教学理念和符合中国一线教学实际的课程教学方法，并对备课资源交流展示活动进行规则解读。</p>\n<p style=\"text-align: justify;\">与此同时，文轩教学资源中心的产品经理们深入到一些区县进行专场沟通，了解当地教师的备课方式，收集教师们的反馈意见，进行了细致的作品准备以及上传方式讲解，从而帮助老师用好资源、备好课程。</p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #c01a00; color: #ffffff;\">评价多元化，重构课堂多样化</span></p>\n<p style=\"text-align: justify;\">此外，本次评比活动采用了教学内容、教学设计、技术性、艺术性等多元化评比方式，鼓励教师们去打破千篇一律的备课模式，开创别具一格的备课角度，探寻全新的备课思路&hellip;&hellip;不断去探索如何让一堂课高效且激动人心。</p>\n<p style=\"text-align: justify;\">&nbsp;</p>', '袁健智', 0, '青羊区', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242002417_c4142.png', NULL, '评比活动，促进备课方式再升级', '', '资源中心');
INSERT INTO `t_article` VALUES (79, 1, '1', '工具的有效，应该是时间的有效', '2020-10-21 17:06:54', '2020-10-28 12:13:45', '袁健智', 4, 112, '<p style=\"text-align: justify;\">2020年9月17日，在成都市金牛区教科院举行的&ldquo;金牛区学科教学资源应用培训会&rdquo;上，文轩教学资源中心面向全区70余所中小学老师，开展了产品培训与分享。</p>\n<p style=\"text-align: justify;\"><span style=\"color: #ffffff; background-color: #c01a30;\">培训促进教学使用</span></p>\n<p style=\"text-align: justify;\">通过现场的产品介绍演示，教研员与老师们对学科教材版本全面覆盖、资源类型多样、使用操作便捷、资源更新紧扣教学进度等方面有了更为清晰的认知。而随着全区范围44所学校的引入，优质的电子教学资源将切实地服务学校的日常教学工作。</p>\n<p style=\"text-align: justify;\"><span style=\"background-color: #c01a30; color: #ffffff;\">备课的核心是备学生</span></p>\n<p style=\"text-align: justify;\">&ldquo;当下的备课对于老师的要求越来越高，而学情是一切教学的起点，在备课因素中最核心的是备学生，真正好用的资源和工具，其实是让老师们备教材和备教法的时间更高效，用更多的时间去了解和掌握学生情况，努力确定学科知识与学生认知之间的最佳结合点。&rdquo;金牛区的一名教师在交流时谈到。</p>\n<p><img src=\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242567845_c5b5a.jpg\" alt=\"\" width=\"100\" height=\"75\" /></p>', '袁健智', 0, '青羊区', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242305455_f4768.png', NULL, '工具的有效，应该是时间的有效', '', '资源中心');
COMMIT;

-- ----------------------------
-- Table structure for t_article_module
-- ----------------------------
DROP TABLE IF EXISTS `t_article_module`;
CREATE TABLE `t_article_module` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `article_module_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '栏目名称',
  `article_module_desc` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '栏目描述',
  `creator` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `count` int(8) DEFAULT '0' COMMENT '文章数量',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for t_banner
-- ----------------------------
DROP TABLE IF EXISTS `t_banner`;
CREATE TABLE `t_banner` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT,
  `banner_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `banner_image_url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `banner_link` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `creator` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `click_count` int(20) DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  `banner_type` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_banner
-- ----------------------------
BEGIN;
INSERT INTO `t_banner` VALUES (20, '地理', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-28/1603845098202_affa3.png', '{\"type\":1,\"link\":\"\",\"linkn\":\"76\"}', '超级管理员', '2020-10-28 16:31:47', NULL, 0, 1);
INSERT INTO `t_banner` VALUES (21, '资源中心', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-28/1603845196214_a6633.jpg', '{\"type\":1,\"linkn\":\"78\",\"linkw\":\"\"}', '超级管理员', '2020-10-28 16:33:27', NULL, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for t_case
-- ----------------------------
DROP TABLE IF EXISTS `t_case`;
CREATE TABLE `t_case` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '地点',
  `case_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '案例名称',
  `case_desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '案例描述',
  `image_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片url',
  `submit_org_id` bigint(64) DEFAULT NULL COMMENT '机构id',
  `submit_org_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '机构名称',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '删除标记',
  `creator` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建人',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态：1:未读；2：已读；3：已采纳',
  `reply_message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '回复消息',
  `creator_id` bigint(64) DEFAULT NULL COMMENT '创建人id',
  `org_id` bigint(64) DEFAULT NULL COMMENT '提交人机构id',
  `org_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '提交人机构名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_case
-- ----------------------------
BEGIN;
INSERT INTO `t_case` VALUES (12, '2020-10-23 11:24:33', '22', '33', '444444', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-23/1603394671862_23912.o6zAJswHdYOV7i67DL1V0WGVI59s', 1, '文轩教育', 0, '超级管理员', 3, '', 2, 1, '文轩教育');
INSERT INTO `t_case` VALUES (13, '2020-10-23 20:10:29', '悦来', '中国教育装备展', '小记', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-23/1603425991438_59332.jpg', 1, '文轩教育', 0, '销售小助手', 3, '', 58, 1, '文轩教育');
INSERT INTO `t_case` VALUES (14, '2020-10-26 11:09:48', '大源国际', '测试', '12755585388668886552666633666655889965587426611111114447444777558856653698568663955896655778966877426968699889999888', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652964467_2856e.jpg', 1, '文轩教育', 0, '销售小助手', 2, '', 58, 1, '文轩教育');
INSERT INTO `t_case` VALUES (15, '2020-10-26 18:01:45', '测试', '测试', '测试', '', 1, '文轩教育', 0, '超级管理员', 1, '', 2, 1, '文轩教育');
INSERT INTO `t_case` VALUES (16, '2020-10-28 09:54:24', '1111', '53586358', '25866', '', 1, '文轩教育', 0, '销售小助手', 1, '', 58, 1, '文轩教育');
INSERT INTO `t_case` VALUES (17, '2020-10-28 09:56:11', '5568', '558666', '566889639', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-28/1603821368854_5e9cf.jpg', 1, '文轩教育', 0, '销售小助手', 1, '', 58, 1, '文轩教育');
INSERT INTO `t_case` VALUES (18, '2020-10-28 09:57:26', '56883', '他都是', '回家路上', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-28/1603821434534_67754.jpg', 1, '文轩教育', 0, '销售小助手', 2, '', 58, 1, '文轩教育');
INSERT INTO `t_case` VALUES (19, '2020-10-28 10:04:36', '4548', '不可能', '家具城', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-28/1603821874272_bdff7.jpg', 13, '研学实践', 0, '销售小助手', 1, '', 58, 12, '蓉城中心');
INSERT INTO `t_case` VALUES (20, '2020-10-28 20:37:57', '银海', '1', '1', '', 1, '文轩教育', 0, '袁健智', 2, '', 58, 13, '研学实践');
INSERT INTO `t_case` VALUES (21, '2020-10-29 10:46:37', '重庆', '展会参观', '重庆教装展盛大开幕', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603910665662_74ffb.jpg', 1, '文轩教育', 0, '杨璐頔', 1, '', 59, 1, '文轩教育');
COMMIT;

-- ----------------------------
-- Table structure for t_feedback
-- ----------------------------
DROP TABLE IF EXISTS `t_feedback`;
CREATE TABLE `t_feedback` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '标题',
  `creator` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` tinyint(1) DEFAULT '0' COMMENT '0:未读，1：已读',
  `reply_message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '回复消息',
  `content` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '文章内容',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  `article_id` bigint(64) DEFAULT NULL COMMENT '文章id',
  `article_content` text COLLATE utf8mb4_unicode_ci COMMENT '文章内容',
  `image_url` text COLLATE utf8mb4_unicode_ci COMMENT '图片url',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for t_material
-- ----------------------------
DROP TABLE IF EXISTS `t_material`;
CREATE TABLE `t_material` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '物料分类/物料名称',
  `file_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '文件url',
  `type` tinyint(1) DEFAULT '1' COMMENT '1:分类，2:文件',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  `parent_id` bigint(64) DEFAULT '0' COMMENT '父物料分类id/父物料Id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_material
-- ----------------------------
BEGIN;
INSERT INTO `t_material` VALUES (26, '文轩教育的活动宣传', '', 1, 0, 0);
INSERT INTO `t_material` VALUES (27, '测试', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-23/1603427022068_822c7.jpg', 2, 0, 26);
INSERT INTO `t_material` VALUES (28, '移动历史教室', 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-23/1603427103261_2ca77.移动历史教室', 2, 1, 26);
COMMIT;

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `menu_code` varchar(45) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '菜单编码',
  `menu_name` varchar(150) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '菜单名称',
  `parent_menu_code` varchar(45) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '父菜单编码',
  `parent_menu_id` bigint(64) DEFAULT NULL COMMENT '父菜单id',
  `parent_menu_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '父菜单名称',
  `app_id` bigint(64) DEFAULT NULL COMMENT '应用id',
  `link` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '菜单链接',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of t_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_menu` VALUES (1, '1', '应用管理', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (2, '2', '应用角色', '0', 0, NULL, NULL, '');
INSERT INTO `t_menu` VALUES (3, '3', '机构管理', '0', 0, NULL, NULL, '');
INSERT INTO `t_menu` VALUES (4, '4', '员工管理', '0', 0, NULL, NULL, '');
INSERT INTO `t_menu` VALUES (5, '5', '区域信息', '0', 0, NULL, NULL, '');
INSERT INTO `t_menu` VALUES (6, '6', '机构管理', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (7, '7', '员工管理', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (8, '8', '账号管理', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (9, '9', '账号管理', '8', 8, '账号管理', NULL, '');
INSERT INTO `t_menu` VALUES (10, '10', '角色管理', '8', 8, '账号管理', NULL, '');
INSERT INTO `t_menu` VALUES (11, '11', '内容发布', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (12, '12', '内容发布', '11', 11, '内容发布', NULL, '');
INSERT INTO `t_menu` VALUES (13, '13', '内容审核', '11', 11, '内容发布', NULL, '');
INSERT INTO `t_menu` VALUES (14, '14', '产品发布', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (15, '15', '分类管理', '14', 14, '产品发布', NULL, '');
INSERT INTO `t_menu` VALUES (16, '16', '分类模板', '14', 14, '产品发布', NULL, '');
INSERT INTO `t_menu` VALUES (17, '17', '学习模式', '16', 16, '分类模板', NULL, '');
INSERT INTO `t_menu` VALUES (18, '18', '宣传模式', '16', 16, '分类模板', NULL, '');
INSERT INTO `t_menu` VALUES (19, '19', '产品管理', '14', 14, '产品发布', NULL, '');
INSERT INTO `t_menu` VALUES (20, '20', '审核发布', '14', 14, '产品发布', NULL, '');
INSERT INTO `t_menu` VALUES (21, '21', '案例管理', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (22, '22', '案例查看', '21', 21, '案例管理', NULL, '');
INSERT INTO `t_menu` VALUES (23, '23', '统计分析', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (24, '24', '总体概况', '23', 23, '统计分析', NULL, '');
INSERT INTO `t_menu` VALUES (25, '25', '使用趋势', '23', 23, '统计分析', NULL, '');
INSERT INTO `t_menu` VALUES (26, '26', '系统配置', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (27, '27', '参数配置', '26', 26, '系统配置', NULL, '');
INSERT INTO `t_menu` VALUES (28, '28', '栏目管理', '26', 26, '系统配置', NULL, '');
INSERT INTO `t_menu` VALUES (29, '29', 'banner管理', '26', 26, '系统配置', NULL, '');
INSERT INTO `t_menu` VALUES (30, '30', '产品信息', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (31, '31', '供应商信息', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (32, '32', '版本信息', '0', 0, '', NULL, '');
INSERT INTO `t_menu` VALUES (33, '33', '功能信息', '0', 0, '', NULL, '');
COMMIT;

-- ----------------------------
-- Table structure for t_organization
-- ----------------------------
DROP TABLE IF EXISTS `t_organization`;
CREATE TABLE `t_organization` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `org_code` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '机构编码',
  `org_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '机构名称',
  `org_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '机构地址',
  `org_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '机构类型：业务组织单位，市公司，分公司，其他',
  `parent_org_code` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '上级机构编码',
  `parent_org_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '上级机构名称',
  `data_scope` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '数据范围/产品范围',
  `account_count` int(8) DEFAULT '0' COMMENT '职员数量',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1:已删除，0：未删除',
  `parent_org_id` bigint(20) DEFAULT '0' COMMENT '上级机构Id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of t_organization
-- ----------------------------
BEGIN;
INSERT INTO `t_organization` VALUES (1, '1001', '文轩教育', '', '业务组织单位', '', '', '', 0, '2020-10-21 12:44:58', '2020-10-21 12:44:58', 0, 0);
INSERT INTO `t_organization` VALUES (12, '1002', '蓉城经营中心', '地址不要了', '市公司', '', '', '蓉城', 0, '2020-10-28 16:55:40', '2020-10-28 16:55:40', 0, 0);
INSERT INTO `t_organization` VALUES (13, '1003', '研学实践', '地址不要了', '业务组织单位', '', '', '巴中,成都,蓉城,达州,德阳,广安,广元,乐山,泸州,眉山,绵阳,南充,内江,攀枝花,遂宁,雅安,宜宾,资阳,自贡', 0, '2020-10-28 10:01:00', '2020-10-28 10:01:00', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_product
-- ----------------------------
DROP TABLE IF EXISTS `t_product`;
CREATE TABLE `t_product` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `product_category_id` bigint(64) DEFAULT NULL COMMENT '产品分类主键',
  `product_category_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '产品分类名称',
  `product_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '产品编码',
  `product_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '产品名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `issue_time` datetime DEFAULT NULL COMMENT '发布时间',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态：1,草稿;2,审核中(待审核);3,已驳回;4,审核通过',
  `read_count` int(8) DEFAULT '0' COMMENT '阅读数量',
  `promotion_times` int(8) DEFAULT '0' COMMENT '促销数量',
  `sale_area` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '销售区域',
  `creator` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建人',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1:已删除，0：未删除',
  `product_content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '产品内容',
  `sort` bigint(64) DEFAULT NULL COMMENT '排序',
  `issue_person` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '发布人',
  `org_id` bigint(64) DEFAULT NULL COMMENT '创建人机构id',
  `image_url` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片链接',
  `audit_person` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '审核人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_product
-- ----------------------------
BEGIN;
INSERT INTO `t_product` VALUES (107, 39, '教育信息化装备', ' 001', ' 移动历史教室', '2020-10-21 17:29:43', '2020-10-27 15:26:03', 4, 263, 25, '', '杨璐頔', 0, '{\"gdurl\":\"\",\"describe\":\"让历史课堂活起来\"}', 1, '杨璐頔', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603243780445_85e35.jpg', '');
INSERT INTO `t_product` VALUES (115, 39, '教育信息化装备', ' 003', '文轩教学资源中心', '2020-10-26 12:27:54', '2020-10-29 16:28:38', 4, 97, 0, '', '杨璐頔', 0, '{\"gdurl\":\"\",\"describe\":\"海量资源  权威高效\"}', 3, '杨璐頔', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603921951014_9954a.jpg', '');
INSERT INTO `t_product` VALUES (116, 39, '教育信息化装备', ' 002', '地理资源包', '2020-10-26 12:35:06', '2020-10-28 17:32:45', 4, 117, 1, '', '杨璐頔', 0, '{\"gdurl\":\"\",\"describe\":\"秒懂地理  轻松趣学\"}', 3, '杨璐頔', 1, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603658101021_4d370.jpg', '');
COMMIT;

-- ----------------------------
-- Table structure for t_product_category
-- ----------------------------
DROP TABLE IF EXISTS `t_product_category`;
CREATE TABLE `t_product_category` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '产品分类名称',
  `category_desc` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '产品分类描述',
  `creator` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `product_count` int(8) DEFAULT '0' COMMENT '产品数量',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  `sort` int(8) DEFAULT '0' COMMENT '产品分类排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_product_category
-- ----------------------------
BEGIN;
INSERT INTO `t_product_category` VALUES (39, '教育信息化装备', '文轩教育科技产品', '杨璐頔', '2020-10-21 15:54:39', 0, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_product_info
-- ----------------------------
DROP TABLE IF EXISTS `t_product_info`;
CREATE TABLE `t_product_info` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `organization_id` bigint(64) DEFAULT NULL COMMENT '业务机构id',
  `product_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '产品编号',
  `product_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '产品名称',
  `supplier_id` bigint(64) DEFAULT NULL COMMENT '供应商id',
  `supplier_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '供应商名称',
  `organization_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '业务机构名称',
  `sale_time` datetime DEFAULT NULL COMMENT '上市时间',
  `learning_stage` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '应用学段',
  `subject` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '应用学科',
  `account_type` tinyint(1) DEFAULT '0' COMMENT '1：用户自建，2，系统分发',
  `version_count` int(8) DEFAULT '0' COMMENT '版本数量',
  `function_count` int(8) DEFAULT '0' COMMENT '功能数量',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_product_info
-- ----------------------------
BEGIN;
INSERT INTO `t_product_info` VALUES (17, 1, ' 001', ' 移动历史教室', 7, '四川寰视乾坤科技有限公司', '文轩教育', '2020-01-01 00:00:00', '初中', '历史', 2, 0, 0, 0);
INSERT INTO `t_product_info` VALUES (18, 1, ' 002', '地理资源包', 7, '四川寰视乾坤科技有限公司', '文轩教育', '2020-01-01 00:00:00', '初中', '地理', 2, 0, 0, 0);
INSERT INTO `t_product_info` VALUES (19, 1, ' 003', '文轩教学资源中心', 8, '四川文轩教育科技有限公司', '文轩教育', '2020-01-01 00:00:00', '小学,初中,中学', '数学', 2, 0, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_product_info_function
-- ----------------------------
DROP TABLE IF EXISTS `t_product_info_function`;
CREATE TABLE `t_product_info_function` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `module_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '模块名称',
  `product_id` bigint(64) DEFAULT NULL COMMENT '产品id',
  `function_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '功能名称',
  `function_desc` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '功能描述',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for t_product_info_version
-- ----------------------------
DROP TABLE IF EXISTS `t_product_info_version`;
CREATE TABLE `t_product_info_version` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `version_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '版本编号',
  `version_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '版本名称',
  `price` decimal(10,2) DEFAULT '0.00' COMMENT '销售定价',
  `fix_price_type` tinyint(1) DEFAULT '1' COMMENT '1,按年，2,买断',
  `description` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '版本描述',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  `product_info_id` bigint(64) DEFAULT NULL COMMENT '产品信息Id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for t_product_module
-- ----------------------------
DROP TABLE IF EXISTS `t_product_module`;
CREATE TABLE `t_product_module` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '产品分类主键',
  `module_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文章模块名称',
  `module_type` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文章模块类型',
  `creator` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_required` tinyint(1) DEFAULT '0' COMMENT '是否必须：0,非必须;1,必须的',
  `is_internal` tinyint(1) DEFAULT '0' COMMENT '是否为内部：0,非内部;1,内部',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  `product_category_id` bigint(64) DEFAULT NULL COMMENT '产品分类主键',
  `sort` bigint(64) DEFAULT NULL COMMENT '产品栏目排序',
  `product_count` int(8) DEFAULT '0' COMMENT '产品数量',
  `pattern` tinyint(1) DEFAULT '1' COMMENT '模式:0,宣传模式;1,学习模式',
  `is_sense` tinyint(1) DEFAULT '0' COMMENT '1:是；0：不是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=438 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_product_module
-- ----------------------------
BEGIN;
INSERT INTO `t_product_module` VALUES (402, 'logo', '图片', '杨璐頔', '2020-10-21 17:33:34', 1, 0, 0, 39, 1, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (403, '介绍视频', '视频', '杨璐頔', '2020-10-21 17:33:45', 1, 0, 0, 39, 2, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (404, '介绍文字', '图片', '杨璐頔', '2020-10-21 17:33:56', 1, 0, 0, 39, 3, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (405, '产品特点', '图片', '杨璐頔', '2020-10-21 17:34:18', 1, 0, 0, 39, 4, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (406, '轮播1', '按钮轮播', '杨璐頔', '2020-10-21 17:34:32', 1, 0, 0, 39, 5, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (407, '轮播1配', '图片', '杨璐頔', '2020-10-21 17:34:45', 1, 0, 0, 39, 6, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (408, '轮播2', '按钮轮播', '杨璐頔', '2020-10-21 17:34:51', 1, 0, 0, 39, 7, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (409, '轮播2配', '图片', '杨璐頔', '2020-10-21 17:34:58', 1, 0, 0, 39, 8, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (410, '产品特点2', '图片', '杨璐頔', '2020-10-21 17:35:14', 1, 0, 0, 39, 9, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (411, '轮播3', '按钮轮播', '杨璐頔', '2020-10-21 17:35:27', 1, 0, 0, 39, 10, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (412, '轮播3配', '图片', '杨璐頔', '2020-10-21 17:35:36', 1, 0, 0, 39, 11, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (413, '应用情况', '图片', '杨璐頔', '2020-10-21 17:35:49', 1, 0, 0, 39, 12, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (414, '应用场景', '图片', '杨璐頔', '2020-10-21 17:36:23', 1, 0, 0, 39, 12, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (415, '产品亮相', '图片', '杨璐頔', '2020-10-21 17:36:46', 1, 0, 0, 39, 13, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (416, '赛课展示', '图片', '杨璐頔', '2020-10-21 17:37:08', 1, 0, 0, 39, 14, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (417, '课堂应用', '图片', '杨璐頔', '2020-10-21 17:37:21', 1, 0, 0, 39, 15, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (418, '产品操作视频', '视频', '杨璐頔', '2020-10-21 17:37:35', 1, 0, 0, 39, 17, 0, 0, 0);
INSERT INTO `t_product_module` VALUES (430, 'logo1', '图片', '杨璐頔', '2020-10-26 16:00:23', 0, 1, 0, 39, 1, 0, 1, 0);
INSERT INTO `t_product_module` VALUES (431, '学习视频', '视频', '杨璐頔', '2020-10-26 16:00:43', 1, 0, 0, 39, 2, 0, 1, 0);
INSERT INTO `t_product_module` VALUES (432, '产品卖点', '图片', '杨璐頔', '2020-10-26 16:01:44', 0, 1, 0, 39, 3, 0, 1, 0);
INSERT INTO `t_product_module` VALUES (433, '销售方式', '图片', '杨璐頔', '2020-10-26 16:02:10', 0, 1, 0, 39, 4, 0, 1, 0);
INSERT INTO `t_product_module` VALUES (434, 'xx', '富文本', '杨璐頔', '2020-10-26 16:02:21', 1, 0, 0, 39, 5, 0, 1, 0);
INSERT INTO `t_product_module` VALUES (435, '硬件卖点', '视频', '杨璐頔', '2020-10-26 16:02:40', 1, 0, 0, 39, 6, 0, 1, 0);
INSERT INTO `t_product_module` VALUES (436, '软件卖点', '视频', '杨璐頔', '2020-10-26 16:03:03', 1, 0, 0, 39, 7, 0, 1, 0);
INSERT INTO `t_product_module` VALUES (437, '售后服务', '图片', '杨璐頔', '2020-10-26 16:03:15', 0, 1, 0, 39, 8, 0, 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_product_module_content
-- ----------------------------
DROP TABLE IF EXISTS `t_product_module_content`;
CREATE TABLE `t_product_module_content` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `product_module_id` bigint(64) DEFAULT NULL COMMENT '栏目主键',
  `product_id` bigint(64) DEFAULT NULL COMMENT '产品主键',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '内容,存储文件上传的url等',
  `module_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '产品栏目名称',
  `file_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '存储上传的文件名字',
  `pattern` tinyint(1) DEFAULT NULL COMMENT '分类描述：0，宣传模式，1，学习模式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_product_module_content
-- ----------------------------
BEGIN;
INSERT INTO `t_product_module_content` VALUES (1114, 379, 105, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240227164_feed4.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo名称', '', 0);
INSERT INTO `t_product_module_content` VALUES (1115, 380, 105, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240247933_1a2c3.mp4\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240239039_3718d.jpg\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '视频介绍', '', 0);
INSERT INTO `t_product_module_content` VALUES (1116, 381, 105, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"<p style=\\\"text-align: center;\\\"><strong>移动历史教室</strong></p>\\n<p style=\\\"text-align: center;\\\">软件+硬件 轻量便携</p>\\n<p style=\\\"text-align: center;\\\">数字化融媒体初中教学创新辅助工具</p>\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '文字介绍', '', 0);
INSERT INTO `t_product_module_content` VALUES (1117, 382, 105, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"<p><img src=\\\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240747345_88346.jpg\\\" alt=\\\"\\\" width=\\\"750\\\" height=\\\"240\\\" /></p>\\n<p>&nbsp;</p>\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点', '', 0);
INSERT INTO `t_product_module_content` VALUES (1118, 383, 105, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240800564_ac9ba.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"3D互动文物\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240934011_a0efd.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"VR全景漫游\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603240982736_8beee.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"互动板书\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1', '', 0);
INSERT INTO `t_product_module_content` VALUES (1119, 379, 106, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242044797_9a8d3.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo名称', '', 0);
INSERT INTO `t_product_module_content` VALUES (1120, 380, 106, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242070339_92125.mp4\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242061403_00169.jpg\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '视频介绍', '', 0);
INSERT INTO `t_product_module_content` VALUES (1121, 381, 106, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242206588_974a1.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '文字介绍', '', 0);
INSERT INTO `t_product_module_content` VALUES (1122, 382, 106, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242237654_c80c9.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点', '', 0);
INSERT INTO `t_product_module_content` VALUES (1123, 383, 106, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242261587_5d9df.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"3D互动文物\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242291932_3bba3.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"VR全景漫游\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603242318258_a5cb8.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"互动板书\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1', '', 0);
INSERT INTO `t_product_module_content` VALUES (1124, 387, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播配图1', '', 0);
INSERT INTO `t_product_module_content` VALUES (1125, 388, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1126, 389, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播配图2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1127, 390, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1128, 391, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3组', '', 0);
INSERT INTO `t_product_module_content` VALUES (1129, 392, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3配图', '', 0);
INSERT INTO `t_product_module_content` VALUES (1130, 393, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用场景', '', 0);
INSERT INTO `t_product_module_content` VALUES (1131, 398, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '课堂应用', '', 0);
INSERT INTO `t_product_module_content` VALUES (1132, 397, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '赛课展示', '', 0);
INSERT INTO `t_product_module_content` VALUES (1133, 396, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '活动宣讲', '', 0);
INSERT INTO `t_product_module_content` VALUES (1134, 395, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品亮相', '', 0);
INSERT INTO `t_product_module_content` VALUES (1135, 394, 106, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用情况', '', 0);
INSERT INTO `t_product_module_content` VALUES (1226, 402, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo', '', 0);
INSERT INTO `t_product_module_content` VALUES (1227, 403, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (1228, 404, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍文字', '', 0);
INSERT INTO `t_product_module_content` VALUES (1229, 405, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点', '', 0);
INSERT INTO `t_product_module_content` VALUES (1230, 406, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1', '', 0);
INSERT INTO `t_product_module_content` VALUES (1231, 407, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1232, 408, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1233, 409, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1234, 410, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1235, 411, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3', '', 0);
INSERT INTO `t_product_module_content` VALUES (1236, 412, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1237, 414, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用场景', '', 0);
INSERT INTO `t_product_module_content` VALUES (1238, 413, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用情况', '', 0);
INSERT INTO `t_product_module_content` VALUES (1239, 415, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品亮相', '', 0);
INSERT INTO `t_product_module_content` VALUES (1240, 416, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '赛课展示', '', 0);
INSERT INTO `t_product_module_content` VALUES (1241, 417, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '课堂应用', '', 0);
INSERT INTO `t_product_module_content` VALUES (1242, 418, 111, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品操作视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (1243, 419, 111, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-23/1603425415463_0fa62.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '联系我们', '', 0);
INSERT INTO `t_product_module_content` VALUES (1244, 402, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo', '', 0);
INSERT INTO `t_product_module_content` VALUES (1245, 403, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (1246, 404, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍文字', '', 0);
INSERT INTO `t_product_module_content` VALUES (1247, 405, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点', '', 0);
INSERT INTO `t_product_module_content` VALUES (1248, 406, 110, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-23/1603425446315_8dc78.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1', '', 0);
INSERT INTO `t_product_module_content` VALUES (1249, 407, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1250, 408, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1251, 409, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1252, 410, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1253, 411, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3', '', 0);
INSERT INTO `t_product_module_content` VALUES (1254, 412, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1255, 414, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用场景', '', 0);
INSERT INTO `t_product_module_content` VALUES (1256, 413, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用情况', '', 0);
INSERT INTO `t_product_module_content` VALUES (1257, 415, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品亮相', '', 0);
INSERT INTO `t_product_module_content` VALUES (1258, 416, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '赛课展示', '', 0);
INSERT INTO `t_product_module_content` VALUES (1259, 417, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '课堂应用', '', 0);
INSERT INTO `t_product_module_content` VALUES (1260, 418, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品操作视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (1261, 419, 110, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '联系我们', '', 0);
INSERT INTO `t_product_module_content` VALUES (1396, 402, 113, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603653974618_efcb3.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo', '', 0);
INSERT INTO `t_product_module_content` VALUES (1397, 403, 113, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603654074440_181c4.mp4\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603653978685_76118.jpg\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (1398, 404, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍文字', '', 0);
INSERT INTO `t_product_module_content` VALUES (1399, 405, 113, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603653987697_2d908.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603653992109_59724.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603653996726_34817.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603654002098_dbd00.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603654006654_7941c.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603654011352_5fc03.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点', '', 0);
INSERT INTO `t_product_module_content` VALUES (1400, 406, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1', '', 0);
INSERT INTO `t_product_module_content` VALUES (1401, 407, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1402, 408, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1403, 409, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1404, 410, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1405, 411, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3', '', 0);
INSERT INTO `t_product_module_content` VALUES (1406, 412, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1407, 414, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用场景', '', 0);
INSERT INTO `t_product_module_content` VALUES (1408, 413, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用情况', '', 0);
INSERT INTO `t_product_module_content` VALUES (1409, 415, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品亮相', '', 0);
INSERT INTO `t_product_module_content` VALUES (1410, 416, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '赛课展示', '', 0);
INSERT INTO `t_product_module_content` VALUES (1411, 417, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '课堂应用', '', 0);
INSERT INTO `t_product_module_content` VALUES (1412, 418, 113, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品操作视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (1911, 402, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603244992570_0832c.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo', '', 0);
INSERT INTO `t_product_module_content` VALUES (1912, 403, 107, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603245676179_e5ef0.mp4\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603244999162_942f2.jpg\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (1913, 404, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603750491698_0afc5.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍文字', '', 0);
INSERT INTO `t_product_module_content` VALUES (1914, 405, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603750505925_e7889.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点', '', 0);
INSERT INTO `t_product_module_content` VALUES (1915, 406, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603751840570_00120.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651604779_62aed.png\",\"icon2\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651608440_da48a.png\",\"icontext\":\"3D互动文物  \",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603245732195_141a0.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651613519_fa286.png\",\"icon2\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651616779_f0bce.png\",\"icontext\":\"VR全景漫游  \",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603245746411_9035b.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651628181_fd33c.png\",\"icon2\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651633393_7f26c.png\",\"icontext\":\"互动板书\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652010675_4a9ad.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652074195_8a621.png\",\"icon2\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652079080_d6228.png\",\"icontext\":\"导图点记\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652028179_ae7a1.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652085150_fdc63.png\",\"icon2\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652090435_ca523.png\",\"icontext\":\"互动地图\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652042429_4427d.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652099015_f326d.png\",\"icon2\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603652105497_46b12.png\",\"icontext\":\"时空纵览\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1', '', 0);
INSERT INTO `t_product_module_content` VALUES (1916, 407, 107, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1917, 408, 107, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1918, 409, 107, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1919, 410, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603750516853_46f05.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点2', '', 0);
INSERT INTO `t_product_module_content` VALUES (1920, 411, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603245890406_762a4.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651709016_8fa84.png\",\"icon2\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651715286_27922.png\",\"icontext\":\"即插即用  \",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603245902800_91bfb.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651723380_cd4ed.png\",\"icon2\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603651726474_74bf5.png\",\"icontext\":\"适配各类班班通\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3', '', 0);
INSERT INTO `t_product_module_content` VALUES (1921, 412, 107, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3配', '', 0);
INSERT INTO `t_product_module_content` VALUES (1922, 414, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603246384750_bf22d.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用场景', '', 0);
INSERT INTO `t_product_module_content` VALUES (1923, 413, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603750546018_234c9.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用情况', '', 0);
INSERT INTO `t_product_module_content` VALUES (1924, 415, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754256252_55db9.jpg\",\"url\":\"71\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":true},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754261608_8bd69.png\",\"url\":\"72\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":true}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品亮相', '', 0);
INSERT INTO `t_product_module_content` VALUES (1925, 416, 107, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '赛课展示', '', 0);
INSERT INTO `t_product_module_content` VALUES (1926, 417, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754271991_ab6c6.png\",\"url\":\"73\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":true}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '课堂应用', '', 0);
INSERT INTO `t_product_module_content` VALUES (1927, 418, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-21/1603246030844_157e4.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603666479208_7cb9a.mp4\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603671776859_be63e.jpg\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品操作视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (1928, 430, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754623921_27117.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo1', '', 1);
INSERT INTO `t_product_module_content` VALUES (1929, 431, 107, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603671473718_8bded.4M\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603670899043_4c00b.png\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '学习视频', '', 1);
INSERT INTO `t_product_module_content` VALUES (1930, 432, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754623973_c1e8b.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品卖点', '', 1);
INSERT INTO `t_product_module_content` VALUES (1931, 433, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754630329_f09ea.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754635623_2fbc7.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754640779_37b84.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754650002_4f51a.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '销售方式', '', 1);
INSERT INTO `t_product_module_content` VALUES (1932, 434, 107, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'xx', '', 1);
INSERT INTO `t_product_module_content` VALUES (1933, 435, 107, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603671245985_c8279.mp4\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603671239317_a3ebb.jpg\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '硬件卖点', '', 1);
INSERT INTO `t_product_module_content` VALUES (1934, 436, 107, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603671333337_48ee8.mp4\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603671249912_4dc34.jpg\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '软件卖点', '', 1);
INSERT INTO `t_product_module_content` VALUES (1935, 437, 107, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603754730307_de0c0.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '售后服务', '', 1);
INSERT INTO `t_product_module_content` VALUES (2004, 430, 116, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603757179646_13f10.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo1', '', 1);
INSERT INTO `t_product_module_content` VALUES (2005, 431, 116, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603679778789_4a004.5\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603675359619_f9218.png\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '学习视频', '', 1);
INSERT INTO `t_product_module_content` VALUES (2006, 432, 116, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603757184708_1ea32.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品卖点', '', 1);
INSERT INTO `t_product_module_content` VALUES (2007, 433, 116, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603757188763_91ac8.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603757193845_7b344.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603757198182_fa933.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '销售方式', '', 1);
INSERT INTO `t_product_module_content` VALUES (2008, 434, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'xx', '', 1);
INSERT INTO `t_product_module_content` VALUES (2009, 435, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '硬件卖点', '', 1);
INSERT INTO `t_product_module_content` VALUES (2010, 436, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '软件卖点', '', 1);
INSERT INTO `t_product_module_content` VALUES (2011, 437, 116, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603757215375_6e8b4.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '售后服务', '', 1);
INSERT INTO `t_product_module_content` VALUES (2079, 402, 116, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603662899080_69bfb.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo', '', 0);
INSERT INTO `t_product_module_content` VALUES (2080, 403, 116, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603672168048_19d3e.mp4\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603662911200_7293d.jpg\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (2081, 404, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍文字', '', 0);
INSERT INTO `t_product_module_content` VALUES (2082, 405, 116, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756054046_1f721.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603681627337_58b48.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756058478_68d73.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603681676499_e7381.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756062821_1a4f8.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603682185724_53a3a.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756066804_9b2fc.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603682195196_d9730.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756071666_74004.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603681934007_fafdb.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756077564_82f05.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603683517809_d7cf8.gif\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点', '', 0);
INSERT INTO `t_product_module_content` VALUES (2083, 406, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1', '', 0);
INSERT INTO `t_product_module_content` VALUES (2084, 407, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1配', '', 0);
INSERT INTO `t_product_module_content` VALUES (2085, 408, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2', '', 0);
INSERT INTO `t_product_module_content` VALUES (2086, 409, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2配', '', 0);
INSERT INTO `t_product_module_content` VALUES (2087, 410, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点2', '', 0);
INSERT INTO `t_product_module_content` VALUES (2088, 411, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3', '', 0);
INSERT INTO `t_product_module_content` VALUES (2089, 412, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3配', '', 0);
INSERT INTO `t_product_module_content` VALUES (2090, 414, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用场景', '', 0);
INSERT INTO `t_product_module_content` VALUES (2091, 413, 116, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756084734_c7d6b.jpg\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用情况', '', 0);
INSERT INTO `t_product_module_content` VALUES (2092, 415, 116, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756098224_d5bd8.jpg\",\"url\":\"76\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":true},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756110753_9aeca.jpg\",\"url\":\"75\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":true}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品亮相', '', 0);
INSERT INTO `t_product_module_content` VALUES (2093, 416, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '赛课展示', '', 0);
INSERT INTO `t_product_module_content` VALUES (2094, 417, 116, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603756115363_40cda.jpg\",\"url\":\"74\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":true},{\"img\":\"\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '课堂应用', '', 0);
INSERT INTO `t_product_module_content` VALUES (2095, 418, 116, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品操作视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (2112, 430, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603930678297_bac95.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo1', '', 1);
INSERT INTO `t_product_module_content` VALUES (2113, 431, 115, '{\"cpconent\":[],\"videval\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-26/1603680109896_63b1c.8M\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603930956863_6db99.png\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '学习视频', '', 1);
INSERT INTO `t_product_module_content` VALUES (2114, 432, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603930686456_5c1f5.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603930690592_99c5a.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品卖点', '', 1);
INSERT INTO `t_product_module_content` VALUES (2115, 433, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603930694511_622a8.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603930715594_2dd5e.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '销售方式', '', 1);
INSERT INTO `t_product_module_content` VALUES (2116, 434, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'xx', '', 1);
INSERT INTO `t_product_module_content` VALUES (2117, 435, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '硬件卖点', '', 1);
INSERT INTO `t_product_module_content` VALUES (2118, 436, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '软件卖点', '', 1);
INSERT INTO `t_product_module_content` VALUES (2119, 437, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603930813244_6a39c.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '售后服务', '', 1);
INSERT INTO `t_product_module_content` VALUES (2120, 402, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931165210_e6d40.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', 'logo', '', 0);
INSERT INTO `t_product_module_content` VALUES (2121, 403, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-27/1603759409401_82ef9.png\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍视频', '', 0);
INSERT INTO `t_product_module_content` VALUES (2122, 404, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '介绍文字', '', 0);
INSERT INTO `t_product_module_content` VALUES (2123, 405, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931215124_bdadc.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931219414_9dcfd.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931222590_d1b90.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931226325_c9f60.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931229562_eb4a6.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931234291_2aaed.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false},{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931241151_d0887.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点', '', 0);
INSERT INTO `t_product_module_content` VALUES (2124, 406, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1', '', 0);
INSERT INTO `t_product_module_content` VALUES (2125, 407, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播1配', '', 0);
INSERT INTO `t_product_module_content` VALUES (2126, 408, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2', '', 0);
INSERT INTO `t_product_module_content` VALUES (2127, 409, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播2配', '', 0);
INSERT INTO `t_product_module_content` VALUES (2128, 410, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品特点2', '', 0);
INSERT INTO `t_product_module_content` VALUES (2129, 411, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3', '', 0);
INSERT INTO `t_product_module_content` VALUES (2130, 412, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '轮播3配', '', 0);
INSERT INTO `t_product_module_content` VALUES (2131, 414, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用场景', '', 0);
INSERT INTO `t_product_module_content` VALUES (2132, 413, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931251240_a74b3.png\",\"url\":\"\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":false}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":true,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '应用情况', '', 0);
INSERT INTO `t_product_module_content` VALUES (2133, 415, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931257649_5dc0a.png\",\"url\":\"77\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":true}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品亮相', '', 0);
INSERT INTO `t_product_module_content` VALUES (2134, 416, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931263250_361c6.png\",\"url\":\"79\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":true}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '赛课展示', '', 0);
INSERT INTO `t_product_module_content` VALUES (2135, 417, 115, '{\"cpconent\":[{\"img\":\"https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-29/1603931268268_1676a.png\",\"url\":\"78\",\"text\":\"\",\"icon\":\"\",\"icon2\":\"\",\"icontext\":\"\",\"linknw\":true}],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '课堂应用', '', 0);
INSERT INTO `t_product_module_content` VALUES (2136, 418, 115, '{\"cpconent\":[],\"videval\":\"\",\"videimg\":\"\",\"titleif\":false,\"richtext\":\"\",\"cplink\":\"\",\"cptext\":\"\",\"fileurl\":\"\",\"filename\":\"\",\"webpage\":\"\"}', '产品操作视频', '', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_region
-- ----------------------------
DROP TABLE IF EXISTS `t_region`;
CREATE TABLE `t_region` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `region_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '大区名称',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for t_region_area
-- ----------------------------
DROP TABLE IF EXISTS `t_region_area`;
CREATE TABLE `t_region_area` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `region_id` bigint(64) DEFAULT NULL COMMENT '大区主键id',
  `area_id` bigint(64) DEFAULT NULL COMMENT '区域id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_region_area` (`region_id`,`area_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '角色名称',
  `role_menu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '菜单列表',
  `accunt_count` int(255) DEFAULT '0' COMMENT '账号数量',
  `deleted` tinyint(255) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES (1, 'admin', '', 0, 0);
INSERT INTO `t_role` VALUES (31, '销售小助手', '', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu` (
  `role_id` bigint(64) NOT NULL COMMENT '角色id',
  `menu_id` bigint(64) NOT NULL COMMENT '菜单id',
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_menu_role` (`role_id`,`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=527 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_role_menu` VALUES (1, 1, 1);
INSERT INTO `t_role_menu` VALUES (1, 2, 2);
INSERT INTO `t_role_menu` VALUES (1, 3, 3);
INSERT INTO `t_role_menu` VALUES (1, 4, 4);
INSERT INTO `t_role_menu` VALUES (1, 5, 5);
INSERT INTO `t_role_menu` VALUES (1, 6, 6);
INSERT INTO `t_role_menu` VALUES (1, 7, 7);
INSERT INTO `t_role_menu` VALUES (1, 8, 8);
INSERT INTO `t_role_menu` VALUES (1, 9, 9);
INSERT INTO `t_role_menu` VALUES (1, 10, 10);
INSERT INTO `t_role_menu` VALUES (1, 11, 11);
INSERT INTO `t_role_menu` VALUES (1, 12, 12);
INSERT INTO `t_role_menu` VALUES (1, 13, 13);
INSERT INTO `t_role_menu` VALUES (1, 14, 14);
INSERT INTO `t_role_menu` VALUES (1, 15, 15);
INSERT INTO `t_role_menu` VALUES (1, 16, 16);
INSERT INTO `t_role_menu` VALUES (1, 17, 17);
INSERT INTO `t_role_menu` VALUES (1, 18, 21);
INSERT INTO `t_role_menu` VALUES (1, 19, 22);
INSERT INTO `t_role_menu` VALUES (1, 20, 56);
INSERT INTO `t_role_menu` VALUES (1, 21, 57);
INSERT INTO `t_role_menu` VALUES (1, 22, 58);
INSERT INTO `t_role_menu` VALUES (1, 23, 59);
INSERT INTO `t_role_menu` VALUES (1, 24, 60);
INSERT INTO `t_role_menu` VALUES (1, 25, 62);
INSERT INTO `t_role_menu` VALUES (1, 26, 63);
INSERT INTO `t_role_menu` VALUES (1, 27, 64);
INSERT INTO `t_role_menu` VALUES (1, 28, 65);
INSERT INTO `t_role_menu` VALUES (1, 29, 66);
INSERT INTO `t_role_menu` VALUES (1, 30, 389);
INSERT INTO `t_role_menu` VALUES (1, 31, 390);
INSERT INTO `t_role_menu` VALUES (1, 32, 391);
INSERT INTO `t_role_menu` VALUES (1, 33, 392);
INSERT INTO `t_role_menu` VALUES (31, 11, 511);
INSERT INTO `t_role_menu` VALUES (31, 12, 512);
INSERT INTO `t_role_menu` VALUES (31, 13, 513);
INSERT INTO `t_role_menu` VALUES (31, 14, 514);
INSERT INTO `t_role_menu` VALUES (31, 15, 515);
INSERT INTO `t_role_menu` VALUES (31, 16, 516);
INSERT INTO `t_role_menu` VALUES (31, 17, 517);
INSERT INTO `t_role_menu` VALUES (31, 18, 518);
INSERT INTO `t_role_menu` VALUES (31, 19, 519);
INSERT INTO `t_role_menu` VALUES (31, 20, 520);
INSERT INTO `t_role_menu` VALUES (31, 21, 521);
INSERT INTO `t_role_menu` VALUES (31, 22, 522);
INSERT INTO `t_role_menu` VALUES (31, 26, 523);
INSERT INTO `t_role_menu` VALUES (31, 27, 524);
INSERT INTO `t_role_menu` VALUES (31, 28, 525);
INSERT INTO `t_role_menu` VALUES (31, 29, 526);
COMMIT;

-- ----------------------------
-- Table structure for t_role_staff
-- ----------------------------
DROP TABLE IF EXISTS `t_role_staff`;
CREATE TABLE `t_role_staff` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(64) DEFAULT NULL,
  `staff_id` bigint(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_role_staff` (`role_id`,`staff_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_role_staff
-- ----------------------------
BEGIN;
INSERT INTO `t_role_staff` VALUES (6, 1, 1);
INSERT INTO `t_role_staff` VALUES (31, 1, 2);
INSERT INTO `t_role_staff` VALUES (8, 12, 21);
INSERT INTO `t_role_staff` VALUES (5, 12, 23);
INSERT INTO `t_role_staff` VALUES (21, 12, 34);
INSERT INTO `t_role_staff` VALUES (29, 12, 41);
INSERT INTO `t_role_staff` VALUES (28, 18, 32);
INSERT INTO `t_role_staff` VALUES (25, 18, 40);
INSERT INTO `t_role_staff` VALUES (24, 19, 37);
INSERT INTO `t_role_staff` VALUES (26, 19, 40);
INSERT INTO `t_role_staff` VALUES (9, 21, 21);
INSERT INTO `t_role_staff` VALUES (10, 22, 21);
INSERT INTO `t_role_staff` VALUES (34, 22, 32);
INSERT INTO `t_role_staff` VALUES (35, 24, 18);
INSERT INTO `t_role_staff` VALUES (33, 24, 22);
INSERT INTO `t_role_staff` VALUES (30, 24, 49);
INSERT INTO `t_role_staff` VALUES (36, 28, 50);
INSERT INTO `t_role_staff` VALUES (52, 28, 54);
INSERT INTO `t_role_staff` VALUES (39, 28, 55);
INSERT INTO `t_role_staff` VALUES (51, 28, 57);
INSERT INTO `t_role_staff` VALUES (37, 29, 51);
INSERT INTO `t_role_staff` VALUES (50, 29, 53);
INSERT INTO `t_role_staff` VALUES (38, 30, 52);
INSERT INTO `t_role_staff` VALUES (54, 31, 58);
INSERT INTO `t_role_staff` VALUES (53, 31, 59);
INSERT INTO `t_role_staff` VALUES (55, 31, 60);
INSERT INTO `t_role_staff` VALUES (57, 31, 61);
COMMIT;

-- ----------------------------
-- Table structure for t_staff
-- ----------------------------
DROP TABLE IF EXISTS `t_staff`;
CREATE TABLE `t_staff` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `account` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '账号',
  `staff_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '姓名',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号',
  `is_active` tinyint(1) DEFAULT '0' COMMENT '激活状态：1,已激活；0,未激活',
  `org_code` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '机构编码',
  `org_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '机构名称',
  `role_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '角色名称',
  `is_approval_person` tinyint(1) DEFAULT '0' COMMENT '是否审核人',
  `last_login` datetime DEFAULT NULL COMMENT '最后登录时间',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  `password` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码',
  `salt` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'salt',
  `org_id` bigint(64) DEFAULT NULL COMMENT '机构id',
  `open_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'openId',
  `is_study` tinyint(1) DEFAULT '0' COMMENT '是否学习模式：1：是，0：不是',
  `is_subscribe` tinyint(1) DEFAULT '0' COMMENT '是否订阅',
  `image_url` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像url',
  `read_password` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '阅读密码',
  `is_read_password` tinyint(1) DEFAULT '0' COMMENT '是否需要阅读密码',
  `app_role` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '应用角色列表',
  `role` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '普通角色列表',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of t_staff
-- ----------------------------
BEGIN;
INSERT INTO `t_staff` VALUES (1, 'admin', '系统管理员', '15884495353', 1, '1001', '文轩教育', 'admin', 0, '2020-10-27 10:17:11', 0, 'c89b5df80e83b6749f87ce3e6ce11d74', 'ae66b270-d229-490d-b1d9-ef4df49058d0', 1, 'okU6c5VSKRTm_KJEXmBadP2Ooapk', 0, 0, '', '', 0, 'admin', 'admin');
INSERT INTO `t_staff` VALUES (2, 'superlu', '超级管理员', '17340028709', 1, '1001', '文轩教育', 'admin', 0, '2020-10-30 03:09:21', 0, '11dc8e4297463bd7fb9059d90cfded6a', 'ff9e67fa-4cb1-4394-aeea-1c0599e53df3', 1, 'okU6c5X9ThL0EiUzRSMK_da9UtJg', 0, 0, 'https://oss-winshare.oss-cn-chengdu.aliyuncs.com/winshare-dev/2020-10-02/1601569044783_ff563.jpg', '', 0, '超级管理员', 'admin');
INSERT INTO `t_staff` VALUES (58, '17828123010', '袁健智', '17828123010', 0, '1003', '研学实践', '', 1, '2020-11-02 02:12:50', 0, 'f43fc1a762db720c3f0e3ea07eb78140', 'c08a74e8-ab88-4e6e-bac0-a384965ef68d', 13, 'okU6c5Sh19o56nyfGEXJokgruuew', 1, 0, '', '', 0, '超级管理员,超级管理员', '销售小助手');
INSERT INTO `t_staff` VALUES (59, '18161265886', '杨璐頔', '18161265886', 0, '1001', '文轩教育', '', 1, '2020-11-02 02:05:32', 0, '3d6dfd0fe2716a834b0d90a130922280', '4cbd386d-8526-445a-a5da-4361486f2237', 1, 'okU6c5cOmuNcbje1s0aoj3Wc7qKo', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (60, '13880889620', '向辉', '13880889620', 0, '1001', '文轩教育', '', 1, '2020-10-28 03:54:59', 0, 'ff7c3e97b4582f2299b7a92240933bd5', 'f82e1c33-dd37-42c0-9e6e-16bd35f32e27', 1, 'okU6c5aJ8SkBrLyo40pFzL0MODqU', 0, 0, '', '', 0, '宣传系统管理员', '销售小助手');
INSERT INTO `t_staff` VALUES (61, '15281077147', '刘疏影', '15281077147', 0, '1001', '文轩教育', '', 1, '2020-10-26 10:40:43', 0, '324eedcb27b1c40847e1180c16ac6d19', '93c8dee7-eafb-446d-b37f-d655b98f112a', 1, 'okU6c5ciIFhVUoBkqfH49dDMfLw4', 0, 0, '', '', 0, '宣传系统管理员', '销售小助手');
INSERT INTO `t_staff` VALUES (62, '13551068077', '赵培', '13551068077', 0, '1001', '文轩教育', '', 0, '2020-10-29 09:27:24', 0, '64003d1d5587c2123b3a0c00772f752c', '47bdfb0f-f8eb-4a46-b132-ce0ae26554cd', 1, 'okU6c5fzghrSxwvDC8JgY7Dn8RZ0', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (63, '13678194387', '李可望', '13678194387', 0, '1001', '文轩教育', '', 0, '2020-10-31 03:27:29', 0, '9d841fdabfaf6a9f729cd8d542adfa9c', '92318811-13cc-43cf-8881-0fb141d35d78', 1, 'okU6c5TWtda5f-tFV8LJuvUBGq7w', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (64, '13880638469', '李翔', '13880638469', 0, '1001', '文轩教育', '', 0, '2020-10-28 14:02:14', 0, 'e51575edcce840ec8906cc6e2c9d5cac', 'd29cdfe1-2c46-43f9-ba54-cd025c91cd92', 1, 'okU6c5Y2Rby-liYXXO6FjII71reU', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (65, '13908040901', '胡霖', '13908040901', 0, '1001', '文轩教育', '', 0, NULL, 0, '3791267483c70d5c5b2d920f03553a6f', '63fe22b4-8d84-4bcf-a8b9-16b04600286a', 1, '', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (66, '13008104588', '李枫', '13008104588', 0, '1001', '文轩教育', '', 0, NULL, 0, '9c9ecc01625dcfb7ead46d9c5e8daaed', '15f4deb4-0a14-4656-b550-31091ad59b89', 1, '', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (67, '15828404090', '侯隽', '15828404090', 0, '1001', '文轩教育', '', 0, NULL, 0, 'ae1e7209ed688b084b0d9ec8b6647cac', '5aea5d41-127e-4a45-a343-641a6e6a256d', 1, '', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (68, '18161173517', '韩梅健子', '18161173517', 0, '1001', '文轩教育', '', 0, NULL, 0, '2b19dfe8e80c9f660cece71e2abd7f5a', '2c1a2939-9860-43db-936c-cbfa144a308f', 1, '', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (69, '13880617303', '陈文练', '13880617303', 0, '1001', '文轩教育', '', 0, '2020-10-30 05:49:17', 0, '06bf43ce37c1aa996d6e82faeea6dac2', '087ff755-c7b4-467f-9b82-00718a651265', 1, 'okU6c5XsDTAIPk8iDxzGB639XX4M', 0, 0, '', '', 0, '产品与账号管理员', NULL);
INSERT INTO `t_staff` VALUES (70, '13880703602', '唐思', '13880703602', 0, '1001', '文轩教育', '', 0, NULL, 0, '6252f24a901c06e7b014507c237d6849', 'c46e1e28-88d7-418b-98cc-596c1676b783', 1, '', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (71, '13880397083', '郝晓磊', '13880397083', 0, '1001', '文轩教育', '', 0, '2020-11-02 02:14:18', 0, '29afe2ec8fe13fa7fb52ea852686f74d', 'b6e8237c-4b8f-4bc8-afb4-e6ab0d1f5842', 1, 'okU6c5VLaAJNBEsvvP4_-osqqWxI', 0, 0, '', '', 0, '宣传系统管理员', NULL);
INSERT INTO `t_staff` VALUES (72, '18683512772', '李由', '18683512772', 0, '1001', '文轩教育', '', 0, '2020-10-30 02:14:44', 0, '4df48efb52247526ee2ac1bc7567e1c7', '45b5810c-3cc8-43f1-bd7f-b7da88c781bb', 1, 'okU6c5cLaET8wfaOgCiJLrtPlXbM', 0, 0, '', '', 0, '宣传系统管理员', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_statics
-- ----------------------------
DROP TABLE IF EXISTS `t_statics`;
CREATE TABLE `t_statics` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT,
  `staff_id` bigint(20) NOT NULL COMMENT '职员id',
  `type1` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '类型：文章；产品',
  `type2` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型：1.外部，2.内部',
  `obj_id` bigint(64) NOT NULL COMMENT '内容或产品信息的id',
  `article_submit_count` int(10) DEFAULT '0' COMMENT '案例提交次数',
  `promotion_count` int(10) DEFAULT '0' COMMENT '转发次数',
  `read_count` int(10) DEFAULT '0' COMMENT '阅读次数',
  `create_date` date NOT NULL COMMENT '时间',
  `org_id` bigint(64) DEFAULT NULL COMMENT '机构id',
  `org_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '机构名称',
  `obj_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '内容或产品信息的名称',
  `staff_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '职员姓名',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index1` (`create_date`,`obj_id`,`staff_id`,`type1`(8)) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1307 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_statics
-- ----------------------------
BEGIN;
INSERT INTO `t_statics` VALUES (262, 58, '文章', NULL, 71, 0, 0, 2, '2020-10-21', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '袁健智');
INSERT INTO `t_statics` VALUES (265, 58, '文章', NULL, 72, 0, 0, 2, '2020-10-21', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '袁健智');
INSERT INTO `t_statics` VALUES (267, 2, '文章', NULL, 72, 0, 0, 2, '2020-10-21', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '超级管理员');
INSERT INTO `t_statics` VALUES (271, 58, '文章', NULL, 73, 0, 0, 2, '2020-10-21', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '袁健智');
INSERT INTO `t_statics` VALUES (274, 2, '文章', NULL, 71, 0, 0, 1, '2020-10-21', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '超级管理员');
INSERT INTO `t_statics` VALUES (277, 1, '文章', NULL, 71, 0, 0, 1, '2020-10-21', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '系统管理员');
INSERT INTO `t_statics` VALUES (278, 1, '文章', NULL, 72, 0, 0, 1, '2020-10-21', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '系统管理员');
INSERT INTO `t_statics` VALUES (280, 58, '文章', NULL, 74, 0, 0, 2, '2020-10-21', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '袁健智');
INSERT INTO `t_statics` VALUES (281, 58, '文章', NULL, 75, 0, 0, 2, '2020-10-21', 1, '文轩教育', '带到哪儿，哪儿就是地理课堂', '袁健智');
INSERT INTO `t_statics` VALUES (288, 59, '产品', '宣传模式', 105, 0, 0, 1, '2020-10-21', 1, '文轩教育', ' 移动历史教室', '杨璐頔');
INSERT INTO `t_statics` VALUES (289, 58, '文章', NULL, 77, 0, 0, 1, '2020-10-21', 1, '文轩教育', '一封感谢信，共同抗疫情', '袁健智');
INSERT INTO `t_statics` VALUES (290, 58, '文章', NULL, 79, 0, 0, 2, '2020-10-21', 1, '文轩教育', '工具的有效，应该是时间的有效', '袁健智');
INSERT INTO `t_statics` VALUES (291, 58, '文章', NULL, 78, 0, 0, 2, '2020-10-21', 1, '文轩教育', '评比活动，促进备课方式再升级', '袁健智');
INSERT INTO `t_statics` VALUES (298, 59, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-21', 1, '文轩教育', ' 移动历史教室', '杨璐頔');
INSERT INTO `t_statics` VALUES (305, 58, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-21', 1, '文轩教育', ' 移动历史教室', '销售小助手');
INSERT INTO `t_statics` VALUES (313, 59, '文章', NULL, 71, 0, 0, 1, '2020-10-21', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '杨璐頔');
INSERT INTO `t_statics` VALUES (319, 2, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-21', 1, '文轩教育', ' 移动历史教室', '超级管理员');
INSERT INTO `t_statics` VALUES (324, 58, '文章', NULL, 71, 0, 0, 2, '2020-10-22', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '销售小助手');
INSERT INTO `t_statics` VALUES (325, 58, '文章', NULL, 73, 0, 0, 2, '2020-10-22', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '销售小助手');
INSERT INTO `t_statics` VALUES (326, 58, '产品', '宣传模式', 107, 0, 2, 2, '2020-10-22', 1, '文轩教育', ' 移动历史教室', '销售小助手');
INSERT INTO `t_statics` VALUES (335, 58, '文章', NULL, 79, 0, 0, 2, '2020-10-22', 1, '文轩教育', '工具的有效，应该是时间的有效', '销售小助手');
INSERT INTO `t_statics` VALUES (336, 58, '文章', NULL, 76, 0, 0, 1, '2020-10-22', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '销售小助手');
INSERT INTO `t_statics` VALUES (337, 58, '文章', NULL, 72, 0, 0, 1, '2020-10-22', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '销售小助手');
INSERT INTO `t_statics` VALUES (343, 58, '文章', NULL, 78, 0, 0, 2, '2020-10-22', 1, '文轩教育', '评比活动，促进备课方式再升级', '销售小助手');
INSERT INTO `t_statics` VALUES (351, 58, '文章', NULL, 73, 0, 0, 1, '2020-10-23', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '销售小助手');
INSERT INTO `t_statics` VALUES (352, 58, '文章', NULL, 74, 0, 0, 1, '2020-10-23', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '销售小助手');
INSERT INTO `t_statics` VALUES (353, 58, '文章', NULL, 71, 0, 0, 2, '2020-10-23', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '销售小助手');
INSERT INTO `t_statics` VALUES (354, 2, '文章', NULL, 79, 0, 0, 2, '2020-10-23', 1, '文轩教育', '工具的有效，应该是时间的有效', '超级管理员');
INSERT INTO `t_statics` VALUES (356, 2, '文章', NULL, 74, 0, 0, 2, '2020-10-23', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '超级管理员');
INSERT INTO `t_statics` VALUES (358, 2, '文章', NULL, 71, 0, 0, 2, '2020-10-23', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '超级管理员');
INSERT INTO `t_statics` VALUES (364, 2, '文章', NULL, 77, 0, 0, 2, '2020-10-23', 1, '文轩教育', '一封感谢信，共同抗疫情', '超级管理员');
INSERT INTO `t_statics` VALUES (365, 2, '文章', NULL, 78, 0, 0, 2, '2020-10-23', 1, '文轩教育', '评比活动，促进备课方式再升级', '超级管理员');
INSERT INTO `t_statics` VALUES (367, 2, '文章', NULL, 76, 0, 0, 2, '2020-10-23', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '超级管理员');
INSERT INTO `t_statics` VALUES (368, 2, '文章', NULL, 72, 0, 0, 1, '2020-10-23', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '超级管理员');
INSERT INTO `t_statics` VALUES (371, 2, '产品', '宣传模式', 107, 0, 2, 2, '2020-10-23', 1, '文轩教育', ' 移动历史教室', '超级管理员');
INSERT INTO `t_statics` VALUES (399, 2, '文章', NULL, 73, 0, 0, 1, '2020-10-23', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '超级管理员');
INSERT INTO `t_statics` VALUES (450, 58, '文章', NULL, 78, 0, 0, 2, '2020-10-23', 1, '文轩教育', '评比活动，促进备课方式再升级', '销售小助手');
INSERT INTO `t_statics` VALUES (451, 58, '文章', NULL, 79, 0, 0, 1, '2020-10-23', 1, '文轩教育', '工具的有效，应该是时间的有效', '销售小助手');
INSERT INTO `t_statics` VALUES (452, 58, '文章', NULL, 77, 0, 0, 1, '2020-10-23', 1, '文轩教育', '一封感谢信，共同抗疫情', '销售小助手');
INSERT INTO `t_statics` VALUES (453, 58, '文章', NULL, 76, 0, 0, 1, '2020-10-23', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '销售小助手');
INSERT INTO `t_statics` VALUES (455, 58, '文章', NULL, 72, 0, 0, 1, '2020-10-23', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '销售小助手');
INSERT INTO `t_statics` VALUES (457, 58, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-23', 1, '文轩教育', ' 移动历史教室', '销售小助手');
INSERT INTO `t_statics` VALUES (460, 58, '产品', '宣传模式', 110, 0, 0, 1, '2020-10-23', 1, '文轩教育', '地理资源包', '销售小助手');
INSERT INTO `t_statics` VALUES (473, 59, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-25', 1, '文轩教育', ' 移动历史教室', '杨璐頔');
INSERT INTO `t_statics` VALUES (477, 58, '产品', '学习模式', 107, 0, 2, 2, '2020-10-26', 1, '文轩教育', ' 移动历史教室', '销售小助手');
INSERT INTO `t_statics` VALUES (486, 58, '文章', NULL, 74, 0, 0, 2, '2020-10-26', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '销售小助手');
INSERT INTO `t_statics` VALUES (487, 58, '文章', NULL, 75, 0, 0, 2, '2020-10-26', 1, '文轩教育', '带到哪儿，哪儿就是地理课堂', '销售小助手');
INSERT INTO `t_statics` VALUES (488, 59, '产品', '学习模式', 107, 0, 2, 2, '2020-10-26', 1, '文轩教育', ' 移动历史教室', '杨璐頔');
INSERT INTO `t_statics` VALUES (491, 59, '文章', NULL, 71, 0, 0, 2, '2020-10-26', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '杨璐頔');
INSERT INTO `t_statics` VALUES (494, 59, '文章', NULL, 73, 0, 0, 2, '2020-10-26', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '杨璐頔');
INSERT INTO `t_statics` VALUES (497, 59, '文章', NULL, 72, 0, 0, 2, '2020-10-26', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '杨璐頔');
INSERT INTO `t_statics` VALUES (501, 58, '文章', NULL, 73, 0, 0, 2, '2020-10-26', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '销售小助手');
INSERT INTO `t_statics` VALUES (504, 58, '文章', NULL, 78, 0, 0, 2, '2020-10-26', 1, '文轩教育', '评比活动，促进备课方式再升级', '销售小助手');
INSERT INTO `t_statics` VALUES (511, 58, '文章', NULL, 72, 0, 0, 2, '2020-10-26', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '销售小助手');
INSERT INTO `t_statics` VALUES (512, 58, '文章', NULL, 76, 0, 0, 2, '2020-10-26', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '销售小助手');
INSERT INTO `t_statics` VALUES (526, 58, '文章', NULL, 71, 0, 0, 2, '2020-10-26', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '销售小助手');
INSERT INTO `t_statics` VALUES (531, 58, '文章', NULL, 79, 0, 0, 2, '2020-10-26', 1, '文轩教育', '工具的有效，应该是时间的有效', '销售小助手');
INSERT INTO `t_statics` VALUES (533, 59, '产品', '宣传模式', 113, 0, 0, 2, '2020-10-26', 1, '文轩教育', '地理资源包', '杨璐頔');
INSERT INTO `t_statics` VALUES (568, 58, '文章', NULL, 77, 0, 0, 2, '2020-10-26', 1, '文轩教育', '一封感谢信，共同抗疫情', '销售小助手');
INSERT INTO `t_statics` VALUES (573, 2, '文章', NULL, 71, 0, 0, 1, '2020-10-26', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '超级管理员');
INSERT INTO `t_statics` VALUES (574, 2, '文章', NULL, 74, 0, 0, 2, '2020-10-26', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '超级管理员');
INSERT INTO `t_statics` VALUES (576, 2, '产品', '宣传模式', 107, 0, 2, 2, '2020-10-26', 1, '文轩教育', ' 移动历史教室', '超级管理员');
INSERT INTO `t_statics` VALUES (578, 2, '文章', NULL, 79, 0, 0, 2, '2020-10-26', 1, '文轩教育', '工具的有效，应该是时间的有效', '超级管理员');
INSERT INTO `t_statics` VALUES (585, 2, '文章', NULL, 78, 0, 0, 1, '2020-10-26', 1, '文轩教育', '评比活动，促进备课方式再升级', '超级管理员');
INSERT INTO `t_statics` VALUES (586, 2, '文章', NULL, 77, 0, 0, 1, '2020-10-26', 1, '文轩教育', '一封感谢信，共同抗疫情', '超级管理员');
INSERT INTO `t_statics` VALUES (595, 59, '产品', '学习模式', 116, 0, 0, 2, '2020-10-26', 1, '文轩教育', '地理资源包', '杨璐頔');
INSERT INTO `t_statics` VALUES (598, 59, '文章', NULL, 76, 0, 0, 2, '2020-10-26', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '杨璐頔');
INSERT INTO `t_statics` VALUES (599, 59, '文章', NULL, 74, 0, 0, 2, '2020-10-26', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '杨璐頔');
INSERT INTO `t_statics` VALUES (604, 58, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-26', 1, '文轩教育', '地理资源包', '销售小助手');
INSERT INTO `t_statics` VALUES (628, 2, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-26', 1, '文轩教育', '地理资源包', '超级管理员');
INSERT INTO `t_statics` VALUES (677, 61, '文章', NULL, 71, 0, 0, 2, '2020-10-26', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '刘疏影');
INSERT INTO `t_statics` VALUES (678, 1, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-26', 1, '文轩教育', ' 移动历史教室', '系统管理员');
INSERT INTO `t_statics` VALUES (679, 61, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-26', 1, '文轩教育', ' 移动历史教室', '刘疏影');
INSERT INTO `t_statics` VALUES (681, 1, '文章', NULL, 79, 0, 0, 2, '2020-10-26', 1, '文轩教育', '工具的有效，应该是时间的有效', '系统管理员');
INSERT INTO `t_statics` VALUES (682, 61, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-26', 1, '文轩教育', '地理资源包', '刘疏影');
INSERT INTO `t_statics` VALUES (683, 1, '产品', '宣传模式', 116, 0, 2, 2, '2020-10-26', 1, '文轩教育', '地理资源包', '系统管理员');
INSERT INTO `t_statics` VALUES (688, 61, '文章', NULL, 72, 0, 0, 1, '2020-10-26', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '刘疏影');
INSERT INTO `t_statics` VALUES (690, 61, '文章', NULL, 79, 0, 0, 1, '2020-10-26', 1, '文轩教育', '工具的有效，应该是时间的有效', '刘疏影');
INSERT INTO `t_statics` VALUES (693, 59, '产品', '学习模式', 117, 0, 0, 2, '2020-10-26', 1, '文轩教育', '地理资源包包', '杨璐頔');
INSERT INTO `t_statics` VALUES (696, 59, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-26', 1, '文轩教育', '文轩教学资源中心', '杨璐頔');
INSERT INTO `t_statics` VALUES (698, 59, '文章', NULL, 77, 0, 0, 1, '2020-10-26', 1, '文轩教育', '一封感谢信，共同抗疫情', '杨璐頔');
INSERT INTO `t_statics` VALUES (699, 1, '产品', '宣传模式', 117, 0, 0, 2, '2020-10-26', 1, '文轩教育', '地理资源包包', '系统管理员');
INSERT INTO `t_statics` VALUES (700, 2, '产品', '宣传模式', 117, 0, 0, 1, '2020-10-26', 1, '文轩教育', '地理资源包包', '超级管理员');
INSERT INTO `t_statics` VALUES (703, 61, '产品', '宣传模式', 115, 0, 0, 1, '2020-10-26', 1, '文轩教育', '文轩教学资源中心', '刘疏影');
INSERT INTO `t_statics` VALUES (712, 1, '文章', NULL, 74, 0, 0, 2, '2020-10-26', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '系统管理员');
INSERT INTO `t_statics` VALUES (713, 1, '文章', NULL, 71, 0, 0, 2, '2020-10-26', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '系统管理员');
INSERT INTO `t_statics` VALUES (715, 1, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-26', 1, '文轩教育', '文轩教学资源中心', '系统管理员');
INSERT INTO `t_statics` VALUES (718, 1, '文章', NULL, 77, 0, 0, 2, '2020-10-26', 1, '文轩教育', '一封感谢信，共同抗疫情', '系统管理员');
INSERT INTO `t_statics` VALUES (721, 58, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-26', 1, '文轩教育', '文轩教学资源中心', '销售小助手');
INSERT INTO `t_statics` VALUES (739, 1, '文章', NULL, 75, 0, 0, 2, '2020-10-26', 1, '文轩教育', '带到哪儿，哪儿就是地理课堂', '系统管理员');
INSERT INTO `t_statics` VALUES (744, 1, '文章', NULL, 78, 0, 0, 2, '2020-10-26', 1, '文轩教育', '评比活动，促进备课方式再升级', '系统管理员');
INSERT INTO `t_statics` VALUES (746, 1, '文章', NULL, 76, 0, 0, 2, '2020-10-26', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '系统管理员');
INSERT INTO `t_statics` VALUES (765, 58, '产品', '宣传模式', 117, 0, 0, 2, '2020-10-26', 1, '文轩教育', '地理资源包包', '销售小助手');
INSERT INTO `t_statics` VALUES (797, 60, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-27', 1, '文轩教育', '地理资源包', '向辉');
INSERT INTO `t_statics` VALUES (799, 60, '产品', '宣传模式', 115, 0, 0, 1, '2020-10-27', 1, '文轩教育', '文轩教学资源中心', '向辉');
INSERT INTO `t_statics` VALUES (800, 60, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-27', 1, '文轩教育', ' 移动历史教室', '向辉');
INSERT INTO `t_statics` VALUES (801, 60, '文章', NULL, 71, 0, 0, 2, '2020-10-27', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '向辉');
INSERT INTO `t_statics` VALUES (802, 60, '文章', NULL, 74, 0, 0, 1, '2020-10-27', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '向辉');
INSERT INTO `t_statics` VALUES (805, 2, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-27', 1, '文轩教育', '文轩教学资源中心', '超级管理员');
INSERT INTO `t_statics` VALUES (807, 1, '文章', NULL, 74, 0, 0, 2, '2020-10-27', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '系统管理员');
INSERT INTO `t_statics` VALUES (809, 59, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-27', 1, '文轩教育', ' 移动历史教室', '杨璐頔');
INSERT INTO `t_statics` VALUES (810, 59, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-27', 1, '文轩教育', '地理资源包', '杨璐頔');
INSERT INTO `t_statics` VALUES (813, 59, '文章', NULL, 73, 0, 0, 1, '2020-10-27', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '杨璐頔');
INSERT INTO `t_statics` VALUES (817, 59, '文章', NULL, 74, 0, 0, 1, '2020-10-27', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '杨璐頔');
INSERT INTO `t_statics` VALUES (818, 59, '文章', NULL, 75, 0, 0, 1, '2020-10-27', 1, '文轩教育', '带到哪儿，哪儿就是地理课堂', '杨璐頔');
INSERT INTO `t_statics` VALUES (819, 59, '文章', NULL, 76, 0, 0, 2, '2020-10-27', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '杨璐頔');
INSERT INTO `t_statics` VALUES (822, 2, '产品', '宣传模式', 116, 0, 0, 1, '2020-10-27', 1, '文轩教育', '地理资源包', '超级管理员');
INSERT INTO `t_statics` VALUES (823, 2, '产品', '宣传模式', 117, 0, 0, 1, '2020-10-27', 1, '文轩教育', '地理资源包包', '超级管理员');
INSERT INTO `t_statics` VALUES (826, 58, '产品', '宣传模式', 107, 0, 0, 1, '2020-10-27', 1, '文轩教育', ' 移动历史教室', '销售小助手');
INSERT INTO `t_statics` VALUES (827, 58, '文章', NULL, 79, 0, 0, 2, '2020-10-28', 1, '文轩教育', '工具的有效，应该是时间的有效', '销售小助手');
INSERT INTO `t_statics` VALUES (828, 58, '产品', '学习模式', 107, 0, 2, 2, '2020-10-28', 1, '文轩教育', ' 移动历史教室', '销售小助手');
INSERT INTO `t_statics` VALUES (831, 58, '文章', NULL, 78, 0, 0, 2, '2020-10-28', 1, '文轩教育', '评比活动，促进备课方式再升级', '销售小助手');
INSERT INTO `t_statics` VALUES (833, 58, '文章', NULL, 72, 0, 0, 2, '2020-10-28', 12, '蓉城中心', '移动历史教室，从“拥有它”到“它有用”', '销售小助手');
INSERT INTO `t_statics` VALUES (834, 58, '文章', NULL, 73, 0, 0, 2, '2020-10-28', 12, '蓉城中心', '课堂变成博物馆，近距离领略历史之美', '销售小助手');
INSERT INTO `t_statics` VALUES (835, 58, '文章', NULL, 71, 0, 0, 2, '2020-10-28', 12, '蓉城中心', '让学生爱上历史，一台神器帮到你', '销售小助手');
INSERT INTO `t_statics` VALUES (837, 58, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-28', 12, '蓉城中心', '地理资源包', '销售小助手');
INSERT INTO `t_statics` VALUES (838, 58, '文章', NULL, 74, 0, 0, 2, '2020-10-28', 12, '蓉城中心', '在乡村教育角落，科技之光也可照见', '销售小助手');
INSERT INTO `t_statics` VALUES (839, 58, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-28', 12, '蓉城中心', '文轩教学资源中心', '销售小助手');
INSERT INTO `t_statics` VALUES (841, 58, '文章', NULL, 77, 0, 0, 2, '2020-10-28', 12, '蓉城中心', '一封感谢信，共同抗疫情', '销售小助手');
INSERT INTO `t_statics` VALUES (868, 59, '产品', '宣传模式', 107, 0, 2, 2, '2020-10-28', 1, '文轩教育', ' 移动历史教室', '杨璐頔');
INSERT INTO `t_statics` VALUES (870, 62, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-28', 1, '文轩教育', ' 移动历史教室', '赵培');
INSERT INTO `t_statics` VALUES (871, 62, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-28', 1, '文轩教育', '地理资源包', '赵培');
INSERT INTO `t_statics` VALUES (872, 62, '产品', '宣传模式', 115, 0, 0, 1, '2020-10-28', 1, '文轩教育', '文轩教学资源中心', '赵培');
INSERT INTO `t_statics` VALUES (873, 62, '文章', NULL, 77, 0, 0, 2, '2020-10-28', 1, '文轩教育', '一封感谢信，共同抗疫情', '赵培');
INSERT INTO `t_statics` VALUES (874, 62, '文章', NULL, 79, 0, 0, 2, '2020-10-28', 1, '文轩教育', '工具的有效，应该是时间的有效', '赵培');
INSERT INTO `t_statics` VALUES (875, 62, '文章', NULL, 78, 0, 0, 2, '2020-10-28', 1, '文轩教育', '评比活动，促进备课方式再升级', '赵培');
INSERT INTO `t_statics` VALUES (877, 62, '文章', NULL, 71, 0, 0, 2, '2020-10-28', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '赵培');
INSERT INTO `t_statics` VALUES (881, 62, '文章', NULL, 76, 0, 0, 2, '2020-10-28', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '赵培');
INSERT INTO `t_statics` VALUES (882, 62, '文章', NULL, 75, 0, 0, 1, '2020-10-28', 1, '文轩教育', '带到哪儿，哪儿就是地理课堂', '赵培');
INSERT INTO `t_statics` VALUES (883, 62, '文章', NULL, 72, 0, 0, 2, '2020-10-28', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '赵培');
INSERT INTO `t_statics` VALUES (885, 62, '文章', NULL, 74, 0, 0, 2, '2020-10-28', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '赵培');
INSERT INTO `t_statics` VALUES (908, 58, '文章', NULL, 75, 0, 0, 2, '2020-10-28', 12, '蓉城中心', '带到哪儿，哪儿就是地理课堂', '销售小助手');
INSERT INTO `t_statics` VALUES (916, 60, '产品', '宣传模式', 107, 0, 0, 1, '2020-10-28', 1, '文轩教育', ' 移动历史教室', '向辉');
INSERT INTO `t_statics` VALUES (919, 58, '文章', NULL, 76, 0, 0, 2, '2020-10-28', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '袁健智');
INSERT INTO `t_statics` VALUES (923, 64, '产品', '宣传模式', 107, 0, 0, 1, '2020-10-28', 1, '文轩教育', ' 移动历史教室', '李翔');
INSERT INTO `t_statics` VALUES (924, 64, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-28', 1, '文轩教育', '地理资源包', '李翔');
INSERT INTO `t_statics` VALUES (925, 63, '文章', NULL, 71, 0, 0, 1, '2020-10-28', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '李可望');
INSERT INTO `t_statics` VALUES (937, 64, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-28', 1, '文轩教育', '文轩教学资源中心', '李翔');
INSERT INTO `t_statics` VALUES (973, 59, '文章', NULL, 78, 0, 0, 2, '2020-10-28', 1, '文轩教育', '评比活动，促进备课方式再升级', '杨璐頔');
INSERT INTO `t_statics` VALUES (974, 59, '文章', NULL, 77, 0, 0, 1, '2020-10-28', 1, '文轩教育', '一封感谢信，共同抗疫情', '杨璐頔');
INSERT INTO `t_statics` VALUES (984, 59, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-28', 1, '文轩教育', '文轩教学资源中心', '杨璐頔');
INSERT INTO `t_statics` VALUES (985, 59, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-28', 1, '文轩教育', '地理资源包', '杨璐頔');
INSERT INTO `t_statics` VALUES (995, 2, '产品', '宣传模式', 107, 0, 2, 2, '2020-10-28', 1, '文轩教育', ' 移动历史教室', '超级管理员');
INSERT INTO `t_statics` VALUES (1007, 2, '文章', NULL, 74, 0, 0, 1, '2020-10-28', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '超级管理员');
INSERT INTO `t_statics` VALUES (1053, 2, '文章', NULL, 79, 0, 0, 2, '2020-10-28', 1, '文轩教育', '工具的有效，应该是时间的有效', '超级管理员');
INSERT INTO `t_statics` VALUES (1102, 58, '文章', NULL, 80, 0, 0, 1, '2020-10-28', 1, '文轩教育', 'test', '袁健智');
INSERT INTO `t_statics` VALUES (1165, 59, '文章', NULL, 76, 0, 0, 1, '2020-10-28', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '杨璐頔');
INSERT INTO `t_statics` VALUES (1168, 64, '文章', NULL, 79, 0, 0, 1, '2020-10-28', 1, '文轩教育', '工具的有效，应该是时间的有效', '李翔');
INSERT INTO `t_statics` VALUES (1171, 58, '文章', NULL, 72, 0, 0, 2, '2020-10-29', 13, '研学实践', '移动历史教室，从“拥有它”到“它有用”', '袁健智');
INSERT INTO `t_statics` VALUES (1172, 58, '文章', NULL, 77, 0, 0, 1, '2020-10-29', 13, '研学实践', '一封感谢信，共同抗疫情', '袁健智');
INSERT INTO `t_statics` VALUES (1173, 58, '文章', NULL, 78, 0, 0, 2, '2020-10-29', 13, '研学实践', '评比活动，促进备课方式再升级', '袁健智');
INSERT INTO `t_statics` VALUES (1174, 58, '文章', NULL, 79, 0, 0, 2, '2020-10-29', 13, '研学实践', '工具的有效，应该是时间的有效', '袁健智');
INSERT INTO `t_statics` VALUES (1175, 59, '产品', '宣传模式', 107, 0, 2, 2, '2020-10-29', 1, '文轩教育', ' 移动历史教室', '杨璐頔');
INSERT INTO `t_statics` VALUES (1176, 59, '文章', NULL, 71, 0, 0, 1, '2020-10-29', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '杨璐頔');
INSERT INTO `t_statics` VALUES (1177, 58, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-29', 13, '研学实践', '文轩教学资源中心', '袁健智');
INSERT INTO `t_statics` VALUES (1179, 58, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-29', 13, '研学实践', ' 移动历史教室', '袁健智');
INSERT INTO `t_statics` VALUES (1180, 58, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-29', 13, '研学实践', '地理资源包', '袁健智');
INSERT INTO `t_statics` VALUES (1190, 59, '文章', NULL, 79, 0, 0, 2, '2020-10-29', 1, '文轩教育', '工具的有效，应该是时间的有效', '杨璐頔');
INSERT INTO `t_statics` VALUES (1200, 58, '文章', NULL, 71, 0, 0, 1, '2020-10-29', 13, '研学实践', '让学生爱上历史，一台神器帮到你', '袁健智');
INSERT INTO `t_statics` VALUES (1202, 58, '文章', NULL, 73, 0, 0, 2, '2020-10-29', 13, '研学实践', '课堂变成博物馆，近距离领略历史之美', '袁健智');
INSERT INTO `t_statics` VALUES (1203, 59, '产品', '学习模式', 115, 0, 0, 2, '2020-10-29', 1, '文轩教育', '文轩教学资源中心', '杨璐頔');
INSERT INTO `t_statics` VALUES (1206, 58, '文章', NULL, 76, 0, 0, 1, '2020-10-29', 13, '研学实践', '他屡登湖南卫视，就因为上课有意思', '袁健智');
INSERT INTO `t_statics` VALUES (1214, 59, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-29', 1, '文轩教育', '地理资源包', '杨璐頔');
INSERT INTO `t_statics` VALUES (1219, 69, '产品', '宣传模式', 107, 0, 0, 2, '2020-10-29', 1, '文轩教育', ' 移动历史教室', '陈文练');
INSERT INTO `t_statics` VALUES (1220, 69, '文章', NULL, 73, 0, 0, 1, '2020-10-29', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '陈文练');
INSERT INTO `t_statics` VALUES (1221, 69, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-29', 1, '文轩教育', '文轩教学资源中心', '陈文练');
INSERT INTO `t_statics` VALUES (1247, 59, '文章', NULL, 76, 0, 0, 1, '2020-10-29', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '杨璐頔');
INSERT INTO `t_statics` VALUES (1255, 62, '文章', NULL, 78, 0, 0, 1, '2020-10-29', 1, '文轩教育', '评比活动，促进备课方式再升级', '赵培');
INSERT INTO `t_statics` VALUES (1256, 69, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-30', 1, '文轩教育', '文轩教学资源中心', '陈文练');
INSERT INTO `t_statics` VALUES (1257, 69, '产品', '宣传模式', 107, 0, 2, 2, '2020-10-30', 1, '文轩教育', ' 移动历史教室', '陈文练');
INSERT INTO `t_statics` VALUES (1259, 69, '文章', NULL, 71, 0, 0, 2, '2020-10-30', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '陈文练');
INSERT INTO `t_statics` VALUES (1260, 72, '产品', '宣传模式', 107, 0, 0, 1, '2020-10-30', 1, '文轩教育', ' 移动历史教室', '李由');
INSERT INTO `t_statics` VALUES (1261, 69, '文章', NULL, 73, 0, 0, 2, '2020-10-30', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '陈文练');
INSERT INTO `t_statics` VALUES (1263, 71, '产品', '宣传模式', 115, 0, 0, 2, '2020-10-30', 1, '文轩教育', '文轩教学资源中心', '郝晓磊');
INSERT INTO `t_statics` VALUES (1264, 69, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-30', 1, '文轩教育', '地理资源包', '陈文练');
INSERT INTO `t_statics` VALUES (1266, 69, '文章', NULL, 76, 0, 0, 2, '2020-10-30', 1, '文轩教育', '他屡登湖南卫视，就因为上课有意思', '陈文练');
INSERT INTO `t_statics` VALUES (1270, 71, '产品', '宣传模式', 116, 0, 0, 2, '2020-10-30', 1, '文轩教育', '地理资源包', '郝晓磊');
INSERT INTO `t_statics` VALUES (1273, 71, '产品', '宣传模式', 107, 0, 0, 1, '2020-10-30', 1, '文轩教育', ' 移动历史教室', '郝晓磊');
INSERT INTO `t_statics` VALUES (1275, 71, '文章', NULL, 79, 0, 0, 2, '2020-10-30', 1, '文轩教育', '工具的有效，应该是时间的有效', '郝晓磊');
INSERT INTO `t_statics` VALUES (1276, 71, '文章', NULL, 78, 0, 0, 2, '2020-10-30', 1, '文轩教育', '评比活动，促进备课方式再升级', '郝晓磊');
INSERT INTO `t_statics` VALUES (1277, 71, '文章', NULL, 77, 0, 0, 2, '2020-10-30', 1, '文轩教育', '一封感谢信，共同抗疫情', '郝晓磊');
INSERT INTO `t_statics` VALUES (1292, 69, '文章', NULL, 79, 0, 0, 1, '2020-10-30', 1, '文轩教育', '工具的有效，应该是时间的有效', '陈文练');
INSERT INTO `t_statics` VALUES (1293, 69, '文章', NULL, 78, 0, 0, 1, '2020-10-30', 1, '文轩教育', '评比活动，促进备课方式再升级', '陈文练');
INSERT INTO `t_statics` VALUES (1294, 69, '文章', NULL, 77, 0, 0, 1, '2020-10-30', 1, '文轩教育', '一封感谢信，共同抗疫情', '陈文练');
INSERT INTO `t_statics` VALUES (1297, 69, '文章', NULL, 75, 0, 0, 1, '2020-10-30', 1, '文轩教育', '带到哪儿，哪儿就是地理课堂', '陈文练');
INSERT INTO `t_statics` VALUES (1298, 69, '文章', NULL, 74, 0, 0, 1, '2020-10-30', 1, '文轩教育', '在乡村教育角落，科技之光也可照见', '陈文练');
INSERT INTO `t_statics` VALUES (1301, 63, '产品', '宣传模式', 107, 0, 0, 1, '2020-10-31', 1, '文轩教育', ' 移动历史教室', '李可望');
INSERT INTO `t_statics` VALUES (1302, 63, '文章', NULL, 72, 0, 0, 1, '2020-10-31', 1, '文轩教育', '移动历史教室，从“拥有它”到“它有用”', '李可望');
INSERT INTO `t_statics` VALUES (1303, 63, '文章', NULL, 73, 0, 0, 1, '2020-10-31', 1, '文轩教育', '课堂变成博物馆，近距离领略历史之美', '李可望');
INSERT INTO `t_statics` VALUES (1304, 63, '文章', NULL, 71, 0, 0, 1, '2020-10-31', 1, '文轩教育', '让学生爱上历史，一台神器帮到你', '李可望');
INSERT INTO `t_statics` VALUES (1305, 59, '产品', '宣传模式', 107, 0, 0, 1, '2020-11-02', 1, '文轩教育', ' 移动历史教室', '杨璐頔');
INSERT INTO `t_statics` VALUES (1306, 58, '产品', '学习模式', 115, 0, 0, 1, '2020-11-02', 13, '研学实践', '文轩教学资源中心', '袁健智');
COMMIT;

-- ----------------------------
-- Table structure for t_supplier
-- ----------------------------
DROP TABLE IF EXISTS `t_supplier`;
CREATE TABLE `t_supplier` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `supplier_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '供应商编码',
  `supplier_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '供应商名称',
  `contact_person` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '联系人',
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '电话号码',
  `address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '地址',
  `product_count` int(8) DEFAULT '0' COMMENT '产品数量',
  `app_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '应用id',
  `app_secret_key` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '秘钥',
  `url` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '接口地址',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '1：删除状态，0非删除状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_supplier
-- ----------------------------
BEGIN;
INSERT INTO `t_supplier` VALUES (7, '001', '四川寰视乾坤科技有限公司', '待补充', '待补充', '待补充', 0, '12345678', '', '待补充', 0);
INSERT INTO `t_supplier` VALUES (8, '002', '四川文轩教育科技有限公司', '待补充', '待补充', '待补充', 0, '1234567890', '', '待补充', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_sys_param
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_param`;
CREATE TABLE `t_sys_param` (
  `id` bigint(64) NOT NULL DEFAULT '1' COMMENT '主键',
  `is_necessary_password` tinyint(255) DEFAULT '0' COMMENT '0:查看内部资料不需要密码，1，查看内部资料需要密码',
  `password_min_bit` tinyint(8) DEFAULT '1' COMMENT '密码最小位数',
  `online_time` int(8) DEFAULT '1' COMMENT '在线时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of t_sys_param
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_param` VALUES (1, 0, 4, 1);
COMMIT;

-- ----------------------------
-- Triggers structure for table t_product_category
-- ----------------------------
DROP TRIGGER IF EXISTS `productCateGoryTrigger`;
delimiter ;;
CREATE TRIGGER `productCateGoryTrigger` AFTER INSERT ON `t_product_category` FOR EACH ROW begin
					 
							insert into t_product_module(module_name,module_type,creator,create_time,is_required,is_internal,product_category_id,sort,pattern,is_sense)
							values('产品说明','文字','system',now(),1,1,NEW.id,NEW.id+2,1,1);
							
              insert into t_product_module(module_name,module_type,creator,create_time,is_required,is_internal,product_category_id,sort,pattern,is_sense)
							values('产品特色','文字','system',now(),1,1,NEW.id,NEW.id+3,1,1);
							
							insert into t_product_module(module_name,module_type,creator,create_time,is_required,is_internal,product_category_id,sort,pattern,is_sense)
							values('产品视频','视频','system',now(),1,1,NEW.id,NEW.id+4,1,1);
							
							insert into t_product_module(module_name,module_type,creator,create_time,is_required,is_internal,product_category_id,sort,pattern,is_sense)
							values('应用案例','富文本','system',now(),1,1,NEW.id,NEW.id+5,1,1);
							
							insert into t_product_module(module_name,module_type,creator,create_time,is_required,is_internal,product_category_id,sort,pattern,is_sense)
							values('销售政策','文字','system',now(),1,1,NEW.id,NEW.id+6,1,1);
							
							insert into t_product_module(module_name,module_type,creator,create_time,is_required,is_internal,product_category_id,sort,pattern,is_sense)
							values('操作资料','网页','system',now(),1,1,NEW.id,NEW.id+7,1,1);
           end
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;
